Does anyone know a formula to conditionally format a cell to change color when a date is entered into another cell?
Specifically, I have a date in one cell that turns red when it is 7 days past. I want that cell to then turn to green when I enter a completion date in another cell.
Anyone?
A date is a number, so...
=ISNUMBER(B1)
But make sure this condition is above the red one.
For your next thread, check out all the options for sub forums and pick the one that relates to the question asked.
This sub forum is, "Introduce yourself"
Edit: Thread moved to Worksheet Functions sub-forum.
Last edited by Paul; 05-25-2012 at 06:45 PM.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks