Previous Topic Next Topic

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

Answer 1 / 1
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
encryption message several time in chat
measking -
HelpiOS -

1 response
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses