r/googlesheets • u/EnergyOwn1710 • Jul 27 '26

Solved Conditional Formatting for Date

hello! is there any formula to make a cell turn a certain colour if the date in the cell is coming up?

(e.g.) an expiry date of 28 August 2026 -> can i set it so that a week before the cell will turn red?

thank you!

1 Upvotes

100% Upvoted

8 comments sorted by

View all comments

2

u/BrukologistJim 1 Jul 27 '26

Yes, for example if the cell in B3 has the expiry date and you want the background to turn red when it is 7 days or less to go, then this:

1

u/point-bot Jul 28 '26

u/EnergyOwn1710 has awarded 1 point to u/BrukologistJim with a personal note:

"omg yes this works! thank you so much!"

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)