Excel Formula for Conditional Formatting of Dates

Closed
MRF14B - Jan 20, 2017 at 10:17 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jan 20, 2017 at 12:26 PM
Hello,
I am having trouble coming up with an Excel formula that will provide conditional highlighting to a cell whose corresponding cell is not filled with a date. Basically, I want cell A1 to be highlighted only if cell B1 does not have a date in it after 30 days from the date in A1. Any ideas for how to write this formula?

Thanks!


1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jan 20, 2017 at 12:26 PM
MRF14B, Godd afternoon.

Try to do:

Select A1
Conditional Format Menu

Using formula
=AND(TODAY()-A1>30, B1="")

Format fill colour as you desire.
OK.

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão