I think an easy Conditional Formatting ?
Try this formula instead:
=AND(A10<"",A10=1)
Hope this helps.
Pete
On Feb 23, 5:57*pm, Scott wrote:
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
|