Conditional Formatting Malfunction?

[Guest]

We have Office 2003 with a spreadsheet with 3 columns. A is written text, b
and c currently are general formatting with numbers. When the A1:C20 area
(all cells) and select conditional formatting and say value is greater than
20000 turn red and add a format and say anything greater than 49000 turn
green, the cell value of 50000 (again which is value general) doesn't turn
any color, but the other over 20000 turn red although including all text
fields. Are we doing something incorrect or what is going on?

 

[Ian]

I can't explain why 50000 doesn't change colour, from your description it
should be red. If, as it sounds, the first condition is >20000 then 50000
satisfies that and any conditions listed after that will be ignored

You should have condition 1 is >49000
and condition 2 is >20000.

Text is not numeric and totally confuses conditional formatting based on
numbers. If the entire column is text, then simply remove conditional
formatting from that column. If there are numbers and you need the same
conditions applied, then make the first condition...

Formula Is =ISNUMBER(A2)=FALSE

....with no format set.