Conditional Formatting

Solved/Closed
antower Posts 1 Registration date Friday October 4, 2013 Status Member Last seen October 4, 2013 - Oct 4, 2013 at 06:22 PM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Oct 7, 2013 at 11:20 AM
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

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Oct 4, 2013 at 08:39 PM
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.
0
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!!
0
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Oct 7, 2013 at 11:20 AM
Good morning, Antower

I'm felling very happy to have helped you.

Have a nice day.

Greetings from Brazil.
0