Hello, I'm stuck with a formula I need for conditional formatting. I have several thousand records over several work sheets I need to check, and think conditional formatting is the way to go.
So in column P I have the 'Outcome' field (which is typically Continuing, Achieved or Withdrawn). Q,R and S are date fields. Depending on the the outcome field I need to check the difference between Q-R or Q-S and highlight accordingly.
I'm able to do one or the other but can't see how to check depending on the Outcome field. I appreciate I probably need to have multiple conditional formats rather than just one formula, which I am happy about amending.
Any ideas would be gratefully received.![]()
Bookmarks