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-28-2022, 11:03 AM

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: 143

rollis13 will become famous soon enough

Default

See if I got it right:

=OR(AND(C2="A",TODAY()-A2>30),AND(C2="B",TODAY()-A2>15),AND(C2="C",TODAY()-A2>7))

Reply With Quote