Conditional formatting affects text as well as values

  • Thread starter Thread starter SueG
  • Start date Start date
S

SueG

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.
 
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
 
You've probably applied the conditional formatting to the entire column and
Excel is interpreting the value in your column header as being =>2500. You
can select that single header cell and go to Format | Conditional formatting
and remove the conditional formatting for that cell. Be sure that when you
do that you respond "NO" to apply the changes to all cells with similar
formatting to preserve the conditional formatting for the rest of the column.
 
.. but it also changes the colour of my column heading text to green.
Excel simply evaluates any text as being greater than any real num, that's
why. You could just remove the CF applied in the header row, as per Jerry's
response.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
 
Thanks for the help

Mike H said:
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
Click to expand...
 
Thanks for the help

JLatham said:
You've probably applied the conditional formatting to the entire column and
Excel is interpreting the value in your column header as being =>2500. You
can select that single header cell and go to Format | Conditional formatting
and remove the conditional formatting for that cell. Be sure that when you
do that you respond "NO" to apply the changes to all cells with similar
formatting to preserve the conditional formatting for the rest of the column.
Click to expand...
 
Back
Top