Conditional Formatting Formula

  • Thread starter Thread starter Jay Gustafson
  • Start date Start date
J

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
 
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
Click to expand...
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.
 
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)
 
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
Click to expand...
C will include a due date. Each row will change a color, depending on how
close the due date is coming up.
 
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.
 
Back
Top