Keep the cell the same color
Closed
whitedevil
Posts
2
Registration date
Wednesday 17 March 2010
Status
Member
Last seen
17 March 2010
-
17 Mar 2010 à 16:25
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Mar 2010 à 16:55
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Mar 2010 à 16:55
Related:
- Keep the cell the same color
- Html text color - Guide
- Color 65535 - Guide
- Sound card color code - Guide
- Powertoys color picker - Download - Other
- Rj45 color code - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Mar 2010 à 16:34
17 Mar 2010 à 16:34
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 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Mar 2010 à 16:55
17 Mar 2010 à 16:55
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
17 Mar 2010 à 16:43
thanx