Can someone help me to write a formula to change cell background colors based
on a date.
I have created a training spreadsheet to inform me when individuals are due
for training. At my last job, I created the same spreadsheet but now I cannot
remember the formulas I used.
The cells would remain green if training was in toloerance, turn yellow when
training due date was 30 days out and turn red when the due date passed.
I used a nested if function for the dates but can't remember how to change
the colors.

Select the range you want to highlight
Use conditional formatting with
FORMULA IS option
Use formula like
($A1-Today)30

"postal vet" wrote:

Can someone help me to write a formula to change cell background colors based
on a date.
I have created a training spreadsheet to inform me when individuals are due
for training. At my last job, I created the same spreadsheet but now I cannot
remember the formulas I used.
The cells would remain green if training was in toloerance, turn yellow when
training due date was 30 days out and turn red when the due date passed.
I used a nested if function for the dates but can't remember how to change
the colors.

Hi,

If you will, just a small correction there

($A1-Today())30

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Select the range you want to highlight
Use conditional formatting with
FORMULA IS option
Use formula like
($A1-Today)30

"postal vet" wrote:

Can someone help me to write a formula to change cell background colors
based
on a date.
I have created a training spreadsheet to inform me when individuals are
due
for training. At my last job, I created the same spreadsheet but now I
cannot
remember the formulas I used.
The cells would remain green if training was in toloerance, turn yellow
when
training due date was 30 days out and turn red when the due date passed.
I used a nested if function for the dates but can't remember how to
change
the colors.

Thanks Ashish...

"Ashish Mathur" wrote:

Hi,

If you will, just a small correction there

($A1-Today())30

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Select the range you want to highlight
Use conditional formatting with
FORMULA IS option
Use formula like
($A1-Today)30

"postal vet" wrote:

Can someone help me to write a formula to change cell background colors
based
on a date.
I have created a training spreadsheet to inform me when individuals are
due
for training. At my last job, I created the same spreadsheet but now I
cannot
remember the formulas I used.
The cells would remain green if training was in toloerance, turn yellow
when
training due date was 30 days out and turn red when the due date passed.
I used a nested if function for the dates but can't remember how to
change
the colors.

This does not work. Besides, using the conditional formatting only allows me
to use one color. I am trying to use three colors: green, yellow and red.

"Sheeloo" wrote:

Thanks Ashish...

"Ashish Mathur" wrote:

Hi,

If you will, just a small correction there

($A1-Today())30

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Select the range you want to highlight
Use conditional formatting with
FORMULA IS option
Use formula like
($A1-Today)30

"postal vet" wrote:

Can someone help me to write a formula to change cell background colors
based
on a date.
I have created a training spreadsheet to inform me when individuals are
due
for training. At my last job, I created the same spreadsheet but now I
cannot
remember the formulas I used.
The cells would remain green if training was in toloerance, turn yellow
when
training due date was 30 days out and turn red when the due date passed.
I used a nested if function for the dates but can't remember how to
change
the colors.

You can have upto three conditions and hence three colors.

What condition are your using?

"postal vet" wrote:

This does not work. Besides, using the conditional formatting only allows me
to use one color. I am trying to use three colors: green, yellow and red.

"Sheeloo" wrote:

Thanks Ashish...

"Ashish Mathur" wrote:

Hi,

If you will, just a small correction there

($A1-Today())30

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Select the range you want to highlight
Use conditional formatting with
FORMULA IS option
Use formula like
($A1-Today)30

"postal vet" wrote:

Can someone help me to write a formula to change cell background colors
based
on a date.
I have created a training spreadsheet to inform me when individuals are
due
for training. At my last job, I created the same spreadsheet but now I
cannot
remember the formulas I used.
The cells would remain green if training was in toloerance, turn yellow
when
training due date was 30 days out and turn red when the due date passed.
I used a nested if function for the dates but can't remember how to
change
the colors.