Conditional Formatting Formula

[Jay Gustafson]

Hello,

My question involves conditional formatting formulas.

A1:F10

I would like to set up conditional formats on those series of cells. Column C will include a due date. Each row will change a color, depending on how close the due date is coming up.


If due date is 3 or more weeks away from today's date, then change row color
If due date is 2 weeks away from today's date, then change row color
If due date is less than 1 week away from today's date, then change row color

If hope this makes sense.

Jay

 

[Jason Morin]

Select A1:F10 and set up 3 conditions, using:

=$C1>=TODAY()+21
=$C1>=TODAY()+14
=AND($C1<=TODAY()+7,$C1>=TODAY())

HTH
Jaso
Atlanta, GA

-----Original Message-----
Hello,

My question involves conditional formatting formulas.

A1:F10

I would like to set up conditional formats on those

series of cells. Column C will include a due date. Each
row will change a color, depending on how close the due
date is coming up.

 

[Frank Kabel]

Hi
try the following:
- select cells A1:F10
- goto the conditional format dialog and enter the following formula
(for your first condition):
=$C1>=TODAY()+21

for the other condition use a formula like
=($C1>=TODAY()+14)*($C1<TODAY()+21)

 

[Jay Gustafson]

Hmm, I can get the first formula to work. But not the second

 

[Frank Kabel]

Hi
what is happening with the second one?

 

[Myrna Larson]

You could use these 3 conditional format conditions, in the order I show them.
Select the entire rows, assume C2 is the active cell. Go to Format/Conditional
Formating. For all 3 conditions, select Formula Is, and type the formula in
the formula box.

Condition 1: =($C2-TODAY())>=21
Condition 2: =($C2-TODAY())>=14
Condition 3: =AND(($C2-TODAY())>=1,($C$2-TODAY())<7))

Hello,

My question involves conditional formatting formulas.

A1:F10

I would like to set up conditional formats on those series of cells. Column

C will include a due date. Each row will change a color, depending on how
close the due date is coming up.

 

[Jay Gustafson]

Frank,

I've sent you an e-mail. I don't know what I am doing wrong, but hopefully
you can help me through this.

 

[Frank Kabel]

Hi
i sent you back an example file