Hi,

I am trying to apply conditional formatting so that any dates that are
equal to or greater then today's date turn red. The conditional
formating works fine (whether I used the Formula Is or Cell Value Is
options as I have provided below) on all dates but the problem is that
it also turns any text I have in the column to red, not just the
dates. I do not want the text to change colour at all.

Formula Is option =$A2=TODAY()
or
Cell Value Is option Greater then or equal to
=TODAY()

Can you please tell me if I am doing anything wrong or missing
something.

Thanks!