Conditional Formatting

  • Thread starter Thread starter Lorrie
  • Start date Start date
L

Lorrie

Sorry - I thought that I posted this question, but I have
been unable to find it.

We are using Excel 2002 XP. I understand that text has a
value of 0. But - If I select a column that has a header
row which includes text...the format specifications use
would be like "cell value is" "greater then" "1000" make
the following format changes (font red). Well in this
instance the test entry will also show as red. If text
has a value of 0 then why is it also changed to red as it
does not met the specifications set (i.e. great then
1000.

I know that I can just select the cells below the
heading, buy why should I have too?
 
Text only gets coerced to a value of 0 in math functions.

In the case of comparisons, the comparison will be made between text
and a number, and the value will always be TRUE.

You could use this as your criterion:

CF1: Formula Is =AND(ISNUMBER(A1),A1>1000)
 
Hi Lorrie,

Yes, you did post this seversl days ago, I replied.

Text does not have a value of zero. Text has an explicit
value that is greater than *any* numeric value. Try this:
In a cell, say A1, enter this numeric value 1E+308. That
is one ridiculously large number. Now in A2 enter any text
string you want. In A3 enter this formula =A2>A1. The
result will be TRUE.

So, don't include the *text* header for CF using the
conditions you want to apply.

Biff
 
Back
Top