Forum Discussion
Conditional Formatting dependent on finding references
Hi, I'm trying to figure out how to setup a conditional formatting based on several conditions being formatted in other cells. Basically chaining conditions. In this scenario, I'm trying to docu...
=AND(ISNUMBER(SEARCH("See",$C2)),TODAY()-VLOOKUP($D2,$A$2:$D$17,4,FALSE)<180)
This rule checks if "See" is in column C. This could be what you are looking for. I can't comment on your option (b) which would mean adding a dummy row for "On file" unfortunately.
Unfortunately that didn't work either.
I've attached a scrubbed version of the IRL file. It has a few formulas going on in it, and I didn't figure they'd conflict, but maybe they do.
- I figured it out!
I didn't know that the "4" in your formula related to the column it would be pulling from.
Since in the IRL spreadsheet, it's column I and I'm having it search in relation to A and I ($A$6:$I$555) it would be "9"
Thanks for all your help!