Previous Topic Next Topic

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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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 responses

Answer 1 / 3
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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
Answer 2 / 3
antower
Oct 7, 2013 at 11:10 AM
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
Answer 3 / 3
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses