Changing cell colour depending on the date in

[@JeffersDIY]

WHAT IF I WANT THE DATE BEFOER FORMULA TO MAKE THE CELL TURN RED ONLY 7 DAYS BEFORE THE DATE IN THE CELL?

[@vueittraining]

It’s a bit more complicated. Conditional Formatting, New Rule, use a formula to determine which cells to formulate. Then type =$A1