View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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