In Excel(2003)...how do you set up conditional formatting to change the
background color when a date is entered into the cell. I don't need to
format it to any particular range of dates, I simply want the color to
change to green when I enter a completion date in the cell. Other than
entering a date, the cell would only contain text abbreviations for
certain actions.

I have tried several different formulas and cannot get any to work.

It seems so basic...that is probably why it is stumping me.


Thanks!


--
rmcgal
------------------------------------------------------------------------
rmcgal's Profile: http://www.excelforum.com/member.php...o&userid=26349
View this thread: http://www.excelforum.com/showthread...hreadid=396149