Keep the cell the same color
Closed
whitedevil
Posts
2
Registration date
Wednesday March 17, 2010
Status
Member
Last seen
March 17, 2010
-
Mar 17, 2010 at 04:25 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2010 at 04:55 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2010 at 04:55 PM
Related:
- Keep the cell the same color
- Rj45 color - Guide
- Notepad++ change background color - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Powertoys color picker - Download - Other
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 17, 2010 at 04:34 PM
Mar 17, 2010 at 04:34 PM
change the conditional format formula to include the range. Right now it seems to be set for today() only
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 17, 2010 at 04:55 PM
Mar 17, 2010 at 04:55 PM
There is some thing called "Conditional Formatting". You will find it on HOME tab with Style group.
click on that
click on manage rules. its at the bottom
from the drop down select "this worksheet"
This will show you all the conditional formatting. I am quite sure you will see at least one with formula that has =today()
click on that rule and click on edit
change the formula to
=AND(A1 >=TODAY(), A1 <= TODAY()-7)
A1 is example, make it what ever you had
click on that
click on manage rules. its at the bottom
from the drop down select "this worksheet"
This will show you all the conditional formatting. I am quite sure you will see at least one with formula that has =today()
click on that rule and click on edit
change the formula to
=AND(A1 >=TODAY(), A1 <= TODAY()-7)
A1 is example, make it what ever you had
Mar 17, 2010 at 04:43 PM
thanx