Hi - I have a few conditional formats in place in my workbook to track dates and status' (see below). I am looking to have excel ignore the bottom 2 conditions if the top condition is true. I tried to use the stop if true function, but could not seem to get it to work. Any suggestions? Basically I want the cell to highlight if the date is upcoming or past due as long as the task is still outstanding. If the task is complete, I do not want to have the dates highlighted. Thanks in advance!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Stop conditional formatting based on alternate cell
- Thread starter KaitMWB
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,265
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
If you use the Formula option of Conditional Formatting, you can have multiple conditioms, i.e.
which would check for column G within the past 7 days and column I is not "Complete".
If you use the Formula option of Conditional Formatting, you can have multiple conditioms, i.e.
Excel Formula:
=AND(TODAY()-$G3<7,$I3<>"Complete")
Upvote
1
