Forum Discussion
Solved
Conditional Formatting with Formulas - Help PLease?! :)
Hi All, I am trying to insert a forumula as part of conditional formatting into a tracker on a spreadsheet to highlight expired dates but only when text in another column meets certain criteria....
- I would highlight B2 to B200 and then apply the following formula
=AND( B2<TODAY(), OR(F2="PENDING", F2="IN QUERY") )
It excludes blank cells in column B
Hi Sergei,
Oh great, thank you. That will make a really useful addition! :)
Thanks,
Jen