Previous Topic Next Topic

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
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 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
0
whitedevil Posts 2 Registration date Wednesday March 17, 2010 Status Member Last seen March 17, 2010
Mar 17, 2010 at 04:43 PM
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
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Excel function question
1234ah -
ac3mark -

3 responses