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?