Changing color of a cell if...

Microsoft Office excel 2007 home & stude...
August 15, 2010 at 05:32:49
Specs: Windows Vista
I am basically trying to change the color of a if it is before, if its on or if it goes past a certain number of days. Lets say b8 has Jan 1, 2010 and i want it to be green if its before 21 days, orange if its on the 21st day and turn red if it goes past 21 days. I tried to use Conditional Formatting but i dont think i was inputting anything right because nothing was changing colors. Thanks for the help.

See More: Changing color of a cell if...

Report •

August 15, 2010 at 08:22:04
You will need three conditional formatting formulas

Try these:

1: =$B8=TODAY() - select color Orange

2: =AND($B8<TODAY(),$B8>=TODAY()-20) - select color Green

3: =AND($B8>TODAY(),$B8<=TODAY()+20) - select color Red

(I'm using Excel 2000 so the below is from memory so it may be a bit off.)

To do Conditional Formatting:

1) Select your cell

2) On the ribbon click Conditional Formatting

3) Click on New Rules, it’s near the bottom of the dialog box.

4) Click Use Formula to determine which cells to format.

5) Enter first formula from above

6) Click on the Format button

7) Select the Fill Tab

8) Select color

9) Click OK

10) Click OK

Repeat for the additional two colors


Report •
Related Solutions

Ask Question