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.