I think an easy Conditional Formatting ?
What do you mean by "removed"?
If you delete the contents, then c11 should change to unformatted.
However, if you "remove" the cell by entering a space, then the conditional
format will apply because a space is greater than 1.
Clear the contents of the cell, or use "" as the value, then the conditional
format will not be triggered.
Regards,
Fred
"Scott" wrote in message
...
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:
=A10=1
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?
Thanks
|