Hi,
My first post so was hoping someone could help please?
As a working example: client name is column A and start date is column B - If client name contains the phrase “PS” in column A AND original start date is more than 1 year in column B I need the cell in column B to turn red…
I can't seem to find a formula which will link both columns.
Many thanks!
Bookmarks