Conditional format won't work for cell containing "TODAY()"

[Excelerate2]

Really simple question: I am using Excel 2010 and noticed that if I try to conditional format a cell that contains a formula "=TODAY()", that it won't highlight!
I have tried every combination but can't get it to work, even if I get it to highlight, as soon as I enter the actual date it still stays highlighted!

It's really simple: I just need one cell (I3) to highlight if it contains the formula for today's date "=TODAY()" and also if it is blank.
I am using it as a reminder for the user to enter today's date in the cell (because if they don't then the form will always show today's date and not the date created, etc)
Any help would be great, very frustrating as CF works for everything else except this simple thing.

 

[Coding4Fun]

Hmm I am not sure what would cause it to error there unless that is not a compatible feature with 2010. It works fine for me once I create the defined "DropMenu" range.

If you remove that line?
.Pattern = xlSolid

You could try using the macro recorder if it exists in 2010 to find the code to use to color the cell and then insert accordingly perhaps.

 

[Excelerate2]

It also worked fine for me when I removed the last dropmenu paragraph, so not sure what's up..
Thanks

Really simple question: I am using Excel 2010 and noticed that if I try to conditional format a cell that contains a formula "=TODAY()", that it won't highlight!
I have tried every combination but can't get it to

work, even if I get it to highlight, as soon as I enter the actual date it still stays highlighted!

It's really simple: I just need one cell (I3) to highlight if it contains the formula for today's date "=TODAY()" and also if it is blank.
I am using it as a reminder for the user to enter today's date in the cell (because if they don't then the form will always show today's date and not the date created, etc)
Any help would be great, very frustrating as CF works for everything else except this simple thing.

Hmm I am not sure what would cause it to error there unless that is not a compatible feature with 2010. It works fine for me once I create the defined "DropMenu" range.

If you remove that line?
.Pattern = xlSolid

You could try using the macro recorder if it exists in 2010 to find the code to use to color the cell and then insert accordingly perhaps.

I think I got it now, for some reason the conditional formatting rule may have been conflicting with it because I still had a condition rule in place (ISBlank), I removed it and it works!
Thanks very much for the help!