Problem with conditional formatting dates

[chrissmarlow]

Hi Guys,

Hope you can help because this is driving me mad!

I have a spreadsheet with 7 dates in it (listed below), from cell A1:A7, in cell C1 I have the formula =EOMONTH(TODAY(),0)+1 which at present is 01/08/2011, to give me the first day of the next month.

I want to conditionally format the 7 dates (A1:A7) so that if they occur after the first day of the next month then they will highlight red. I have tried using the greater than formula in conditional formatting but this doesnt seem to work as it highlights "28/07/2011". All cells with data in them are formatted as short date (dd/mm/yyyy).

Can anyone help me out with this?

Dates in cells A1:A7
15/09/2011
29/09/2011
07/05/2011
29/09/2011
15/09/2011
15/09/2011
28/07/2011

 

[chrissmarlow]

I don't know what would have caused it.

Either Text to Columns or format the cells as General and type in the dates again.

Ok, well thanks very much for your help, it was driving me crazy!