Conditional Formatting
Solved/Closed
antower
Posts
1
Registration date
Friday 4 October 2013
Status
Member
Last seen
4 October 2013
-
4 Oct 2013 à 18:22
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 7 Oct 2013 à 11:20
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 7 Oct 2013 à 11:20
Related:
- Conditional Formatting
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- Risk formatting excel - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Conditional formatting between two values ✓ - Excel Forum
3 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
4 Oct 2013 à 20:39
4 Oct 2013 à 20:39
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.
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!!
Thank you for replying!
YOU ARE A LIFE SAVER!!!!!!!!!!!!!!!!!!!!!!!!!!! I CANNOT THANK YOU ENOUGH!!!!!
It worked beautifully!!!!!!!!!!!!!!!!!!!
Have a wonderful day!!
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
7 Oct 2013 à 11:20
7 Oct 2013 à 11:20
Good morning, Antower
I'm felling very happy to have helped you.
Have a nice day.
Greetings from Brazil.
I'm felling very happy to have helped you.
Have a nice day.
Greetings from Brazil.
