Excel cell color conditional changing

Microsoft Excel 2003 (full product)
February 16, 2010 at 20:21:16
Specs: Windows XP
I am trying to change the color of a cell based on the contents of another cell

Date visited: acct : :Date next visit
12/08/10:acct name other data: 12/05/10

When this condition has met I want the whole row to turn red not just one cell. Right now I use Conditional Formatting but it only changes the 12/05/10 cell.

See More: Excel cell color conditional changing

Report •

February 17, 2010 at 08:45:43
Assuming your Date is in cell D2
Your Conditional Formatting should look something like:


The important point is:
Notice the $ symbols are used to anchor the cell reference.

Highlight Cell D2 and

Select the rest of the cells in Row 2

Past Special
Check the Formats selection
Click OK

Should get you want you want.



Report •

February 17, 2010 at 18:14:24
Thank you.

Also noticed that just selecting and inputting the code you gave into the conditional format worked as well and preserved the rest of my formatting. My mistakes was I was not putting TRUE, FALSE in my if statement I was putting formals in there trying to make it do it much.

Just in case anyone tries to do something like I am doing here is the full application of the code

A2 A2-M2 N2 O2 P2 Q2
Visit date : acct data : Min : Max : Reschedule : Overdue

A2:cell that needs updated
A2-O2: Only changed when needed
P2: =IF(N2>0,A2+N2,TODAY()+360)
Q2: =IF(O2>0,A2+O2,TODAY()+360)

Then I Highlighted Rows A2 through R2
..Conditional Formatting
Condition 1
Formula is:: =IF($Q$2<TODAY(),TRUE,FALSE)
Set to red
Condition 2
Set to Yellow
Formula is :: =IF($P$2<TODAY(),TRUE,FALSE)

Then I repeated for the other 62 Accts I have to keep up with.
The benefit is now if I need to schedule a visit it turns yellow. If I go past the time I am contractually allowed to put them off it will turn red so I know to go there ASAP.

Report •

February 17, 2010 at 19:12:15
Glad I could help.



Report •

Related Solutions

Ask Question