Need Help With Conditional Formatting
Closed
Jason
-
Sep 17, 2010 at 05:19 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 17, 2010 at 09:43 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 17, 2010 at 09:43 PM
Hi,
I'm working on a spreadsheet which requires me to have the date in the cell turn yellow if the present date is within 40 days (including the 40th day) of it. And if the present date is within 10 days (including the 10th day) of the date in the cell it needs to turn red. Any help would be appreciated.
Jason
I'm working on a spreadsheet which requires me to have the date in the cell turn yellow if the present date is within 40 days (including the 40th day) of it. And if the present date is within 10 days (including the 10th day) of the date in the cell it needs to turn red. Any help would be appreciated.
Jason
Related:
- Need Help With Conditional Formatting
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- How to format windows 7 with keyboard - Guide
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 17, 2010 at 09:43 PM
Sep 17, 2010 at 09:43 PM
under conditional foramtting
condition 1
the cell value is between -today()+40 and today()+10
condition 2
the cell value is less then =today()+10
condition 1
the cell value is between -today()+40 and today()+10
condition 2
the cell value is less then =today()+10