Keep the cell the same color

Closed
Report
Posts
2
Registration date
Wednesday March 17, 2010
Status
Member
Last seen
March 17, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,I am using excel 2007 and i have cells change color when the date in them is today. I would like to keep the cell the same color for i week after the date, right now the cell changes back to blank when the date changes to the next date. Any help would be great.

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
change the conditional format formula to include the range. Right now it seems to be set for today() only
0
Posts
2
Registration date
Wednesday March 17, 2010
Status
Member
Last seen
March 17, 2010

I am new to excel this is the first 1 that i have tried to do may i ask how to add a range to today() iam not sure how to write code for it to work any help would greatly be help full.

thanx
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
0