conditional formating
 

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

conditional formating
 

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 blank300 = TRUE

--
Biff
Microsoft Excel MVP


"Jase" wrote in message
...
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

conditional formating
 

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" wrote:

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 blank300 = TRUE

--
Biff
Microsoft Excel MVP


"Jase" wrote in message
...
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

conditional formating
 

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

=AND(ISNUMBER(A1),A1300)

--
Biff
Microsoft Excel MVP


"Jase" wrote in message
...
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" wrote:

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 blank300 = TRUE

--
Biff
Microsoft Excel MVP


"Jase" wrote in message
...
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