If a cell value is equal to today I want the colour to change to red. I have
entered =TODAY as a conditional formatting value but the cell colour does not
change. The cell has been formatted as ddd dd mmm. Any ideas please.

Thanks in advance for any help
John