Conditional formatting affects text as well as values
Thanks for the help
"Mike H" wrote:
Hi,
Do it like this instead. Select your column, I used A and then
Format|Conditional format - Formula is and enter the formula
=AND(ISNUMBER(A1),A1<500)
Pick your colour
ClicK add and enter the formula
=AND(ISNUMBER(A1),A1=2500)
and pick your colour
OK
Mike
"SueG" wrote:
I'm using Excel 2003. I have a column of order totals. I have applied
conditional formatting to make any values <500 red and =2500 green. This
works fine but it also changes the colour of my column heading text to green.
Is this correct?
Thanks in advance.
|