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, 03:52 PM

rollis13

rollis13 is offline

rollis13 uses Windows 10

Windows 10 rollis13 uses Office 2016

rollis13 uses Office 2016

Office 2016

Competent Performer

Join Date: Jan 2021

Location: Cordenons

Posts: 142

rollis13 will become famous soon enough

Default

This could be your formula for cell B" with Conditional Formatting with red fill:

=IF(AND(B2=""),TODAY()-A2>30)

Reply With Quote