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.