Automatically change cell color on a certain
Closed
lostntranslation
-
Jun 3, 2010 at 01:20 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2010 at 01:40 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2010 at 01:40 PM
Related:
- Automatically change cell color on a certain
- Notepad++ change background color - Guide
- Change computer name cmd - Guide
- Rj45 color - Guide
- T-mobile change number - Guide
- How to change crosshair color csgo - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 3, 2010 at 01:40 PM
Jun 3, 2010 at 01:40 PM
You are talking about conditional formatting
use conditional formatting
=AND(E11<> "", E11<today() + 30, E11>=Today())
and choose color
Formula says
IF E11 is not blank
AND
E11 is greater or equal to today
AND
E11 is less than 30 days from today
use conditional formatting
=AND(E11<> "", E11<today() + 30, E11>=Today())
and choose color
Formula says
IF E11 is not blank
AND
E11 is greater or equal to today
AND
E11 is less than 30 days from today
