Conditional formatting in empty cells

[Guest]

Using Conditional Formating from the Format menu I am setting the Pattern for
cells containinig a number greater than 6 to Green. This works fine except
empty cells i.e. containing no data, go green.

Has any one got any suggestions?

Best wishes

Nick

 

[Dave Peterson]

Are you sure the cell is empty?

Or do you put a space character in that cell--or do you have a formula that
evaluates to ""?

If it's a formula that evaluates to "", you could use a rule like:

Formula is:
=AND(ISNUMBER(A1),A1>6)

 

[Guest]

Hi Dave

Thanks for getting back to me. The cell is definetly empty.

For information , however you have solved the problem and another one I'm
suffering from.
I just checked the cells format and it's General. I changed it to number
and then applied the Conditional Format and it works fine. If apply Number
format after applying the conditional format the pattern stays green.

So many thaks for your help.