In the excell worksheet, the cell value is as date. I want to conditional formate the cell such that when the system date is equal to cell value, the color of the cell text will change
Format > Conditional Formatting
First drop down leave as: Cell value is
Second drop down select: Equal to
Third drop down type: =TODAY()
Format (button)
Select your format
OK
OK
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
