Date Conditional Formatting

Brittany Lucarell

Hi-

Can someone please assist with how I can a conditional format setup for the below, or does this need to be a formula?

Use case below:

Column Services Date is a date I enter - I would like the entire row to turn yellow if it is has been 15 days from Column Services Date, and to turn entire row red if 20 days since Services Date entered.

Matt Johnson

Hi @Brittany Lucarell

Good morning. There's probably a few different ways to do this. I find adding a hidden column helps in this situation. I hope the screen shot below helps.

Brittany Lucarell

Hi -

Unfortunately that setup won't work for how I want. I have screenshot the sheet to show how it is setup. I would like if the invoice status is blank and its been 15 days since the Service Date entered then to highlight row yellow. Then if the its been 20 days to highlight row red. Does that make sense?