Conditional Formatting [Solved/Closed]

Report
Posts
1
Registration date
Friday October 4, 2013
Status
Member
Last seen
October 4, 2013
-
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
-
Hello,

Does anyone know if you can set conditional formatting to highlight an entire row if the date in a specific cell is less than a week from today?

I have a list of people i need to follow up with at a later date and I want that row to hilight when that date is 5 days away.

Thank you for your help!! :)


3 replies

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Antower, Good evening.

Suppose your date control is at D1

Select Line 1 and at Conditional Formating include a formula: =($D1-TODAY())<=5
Choose your desired format. OK

Is what you desired?
Tell us if it worked for you.

I hope it helps.

Greetings from Brazil.
Good morning Marcílio!

Thank you for replying!

YOU ARE A LIFE SAVER!!!!!!!!!!!!!!!!!!!!!!!!!!! I CANNOT THANK YOU ENOUGH!!!!!

It worked beautifully!!!!!!!!!!!!!!!!!!!

Have a wonderful day!!
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Good morning, Antower

I'm felling very happy to have helped you.

Have a nice day.

Greetings from Brazil.