thexfactor44
New Member
- Joined
- Feb 21, 2002
- Messages
- 26
I need to change the text color in a given cell if it contains yesterday's date. The date is entered in the following format (if it matters):
4/15/02 (for example)
After the next day, all the previous cells that were yesterday's date will be two days ago and I need them to go back to normal black...and the new dates that qualify as yesterday should highlight text. What can I do?
thanks for all responses.
4/15/02 (for example)
After the next day, all the previous cells that were yesterday's date will be two days ago and I need them to go back to normal black...and the new dates that qualify as yesterday should highlight text. What can I do?
thanks for all responses.