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.
Okay thanks, I'll try this formula.
However, I tried the previous formula in the IRL spreadsheet (adjusting for correct columns and row numbers) and it didn't seem to take.
I figured the rule would still work except on the ones where "On File" is the text, since there isn't a match. But it didn't work for things that should've applied.
Maybe it'll like this one better, though.
However, I tried the previous formula in the IRL spreadsheet (adjusting for correct columns and row numbers) and it didn't seem to take.
I figured the rule would still work except on the ones where "On File" is the text, since there isn't a match. But it didn't work for things that should've applied.
Maybe it'll like this one better, though.