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 [email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
