Conditional Formatting Using AND

Cheryl Collins
Cheryl Collins ✭✭✭✭✭✭


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?

Many thanks


Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 04/19/21 Answer ✓

    Hi @Cheryl Collins

    Hope you are fine, i solved the problem of the Family Leave End Date column for you and i created the conditional formatting as you need, please check the sheet you shared.

    As @Paul Newcome and @Andrée Starå i found a problem in Family Leave End Date column.

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"