CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
Miaoulis Nikos
Miaoulis Nikos

Reputation: 182

Conditional formating based on a previous day of a date in a cell

I have a cell with a future date. I want to conditionally format the cell if I am one day before that date.

How I am going to achieve this

Upvotes: 0

Views: 21

Answers (1)

Abe Gold
Abe Gold

Reputation: 2357

Use a formula to determine formatting, for example:

=$A$1=TODAY()-1

Upvotes: 1

Related Questions