conditional formating

[Jase]

I am using a conditional formating across a range of data. My data is linked
up to another sheet, and includes many blank cells. However my condition is
if the cell value is greater than 300 to fill the cell blue. Howvere it is
working bnut it is also filling many random blank cells blue also.

Any idea why?

thanks,

Jase

 

[T. Valko]

The "blank" cells are probably not *empty*. If these cells contain formula
blanks ("") or other unseen characters like spaces then those cells will
"pass" the conditional formatting test and the format will be applied.

In Excel a TEXT value will evaluate to be greater than any numeric value.
So:

"x">300 = TRUE
formula blank>300 = TRUE

 

[Jase]

So I have a lot of cells equaling cells that have absolutely nothing in them.
However it's random what cells r being filled in. All my blank cells should
be filled in, and only about 40% are, if what you are saying is true.


thanks,

JAse

 

[T. Valko]

Use the Formula Is option in conditional formatting and use a formula like
this:

=AND(ISNUMBER(A1),A1>300)