Conditional Formatting

[Solved/Closed]
Report
Posts
1
Registration date
Friday October 4, 2013
Status
Member
Last seen
October 4, 2013
-
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
-
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
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
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
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
Good morning, Antower

I'm felling very happy to have helped you.

Have a nice day.

Greetings from Brazil.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!