Prev: Can't save Excel file. Msg "File" is in use. Try again later.
Next: TRUE: Would like it to appear as "True" in the cell.
From: vttotal on 23 Feb 2010 14:38
I think that you are trying just to give a value when there is an actual
number in cell A10 Right?
If so, this is what you should do:
So what is actually doing is that the formula will only calculate the
condition if there is a number present. Another thing you might do too is to
play around with the "conditional formatting box" in word.
Hope that helps,
> I'm trying to write a Conditional Formatting formula for cell C11, if the
> number in Cell A10 is greater than 1.
> I've been trying this without getting the results that I want:
> This formula will fill cell C11, however when value in A10 is removed, C11
> still remains with that fill, when I want it to be unformatted.
> Any ideas?