Can I please have an amendment to this conditional formatting

[les361800]

I was kindly provided with this formula to turn a cell red when the date was the next day.
The cell however turns back to white when the date is the current date - can it be amended so that it turns red the day before, and stays red when on or past the date?

Thank you

 

[awoohaw]

you have goofy quotes again. put the formula I have in column F and get it so you have the TRUES and FALSES you want. Then take the the EXACT formula in Cell F2, and use that as your CF rule for all the cells beginning with D2, or F1 to D1, or however you want. When you like it, delete column F.

 

[les361800]

you have goofy quotes again. put the formula I have in column F and get it so you have the TRUES and FALSES you want. Then take the the EXACT formula in Cell F2, and use that as your CF rule for all the cells beginning with D2, or F1 to D1, or however you want. When you like it, delete column F.

Thats fixed it!!!

My goodness thank you so much, that was a lot!