Conditional Formatting Using AND
I want to apply conditional formatting to grey a row out where someone is one of the family leave options e.g. Maternity Leave and the date is in the future (as if the date is in the past I don't want it to show as greyed out).
I have added the following conditional formatting but, as you will see from the screen shot the row has not turned grey despite the criteria being met. Any ideas?