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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 7, 2013 at 11:20 AM
Related:
- Conditional Formatting
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Conditional formatting based on date ✓ - Excel Forum
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 4, 2013 at 08:39 PM
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.
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
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 7, 2013 at 11:20 AM
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.
I'm felling very happy to have helped you.
Have a nice day.
Greetings from Brazil.
