Microsoft Office Forums - View Single Post - How do i highlight a cell red if no date has been entered 30 days after a date in another cell??

Thread: How do i highlight a cell red if no date has been entered 30 days after a date in another cell??

View Single Post

Old

07-27-2022, 12:47 PM

Daronovitz Daronovitz is offline

Daronovitz is offline

Daronovitz uses Windows 10

Windows 10 Daronovitz uses Office 2019

Daronovitz uses Office 2019

Office 2019

Novice

The original poster

Join Date: Jul 2022

Posts: 13

Daronovitz is on a distinguished road

Default

How do i highlight a cell red if no date has been entered 30 days after a date in another cell??

Example: Cell A2 contains the date 6/1/22. I want Cell B2 to be highlighted red if nothing is entered in to cell B2 after 30 days. How do I do it?

Reply With Quote