If C12 has the end date and G12 has the status, how can I add a conditional format for the cells to turn red if the end date is greater than today, and the status is anything other than "Completed"
Your help would be greatly appreciated!
Thanks!
If C12 has the end date and G12 has the status, how can I add a conditional format for the cells to turn red if the end date is greater than today, and the status is anything other than "Completed"
Your help would be greatly appreciated!
Thanks!
try this...
=and(c12>today(),g12<>"Completed")
you may have to play around with absoluting ($), depending on what you are doing
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks