CF Problem (2003 SP3)

[steveh]

Afternoon all

I have a range of cells on a WS A1:N33 that are all possibly populated with the results of a cell on another worksheet. I have highlighted them all and gone into CF and Picked the option of cell value less than or = to (0 is what I want) and then font to red but none of the cells less <=0 change. Is this because the values are comong from somewhere else?

[StuartR]

Do the cells definitely contain numbers and not text?

[steveh]

Do the cells definitely contain numbers and not text?

Hi Stuart

Yes, they are all numbers, and just to be sure I set the negative numbers to be red as well but nothing changes?

[HansV]

Could you post a sample workbook?

[steveh]

Could you post a sample workbook?

Hi Hans

Please find attached a stripped down version of the WB, on the map page the temperatures are derived Oops as I type I just realised I have run foul of copying numbers with °'s in them and my brain just accepting they are number when they are not.

I will try and copy them over as per previous examples with the ° and format the cells to put it back.