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.

"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.