add days and shade help
 

i would like to add 90 days to a date and have it stay green, and trun red on
the 80th day can this be done.
--
cj

add days and shade help
 

You can use conditional formatting to achieve your goal. If you have the
original date in A1, and in B1 you have a formula =A1+90, then onditionally
format B1. Iso Cell Value is, use Formula Is, and insert the following
formula: =TODAY()<A1+80

Click on Format, select Patterns, choose Red, and OK out. Set the Cell
Background to Green, and it will remian green till 80 days after the date in
A1, when it will turn red.

"bikerhd" wrote:

i would like to add 90 days to a date and have it stay green, and trun red on
the 80th day can this be done.
--
cj

add days and shade help
 

thanks this works/////
--
cj


"kassie" wrote:

You can use conditional formatting to achieve your goal. If you have the
original date in A1, and in B1 you have a formula =A1+90, then onditionally
format B1. Iso Cell Value is, use Formula Is, and insert the following
formula: =TODAY()<A1+80

Click on Format, select Patterns, choose Red, and OK out. Set the Cell
Background to Green, and it will remian green till 80 days after the date in
A1, when it will turn red.

"bikerhd" wrote:

i would like to add 90 days to a date and have it stay green, and trun red on
the 80th day can this be done.
--
cj

add days and shade help
 

Glad I could help!

"bikerhd" wrote:

thanks this works/////
--
cj


"kassie" wrote:

You can use conditional formatting to achieve your goal. If you have the
original date in A1, and in B1 you have a formula =A1+90, then onditionally
format B1. Iso Cell Value is, use Formula Is, and insert the following
formula: =TODAY()<A1+80

Click on Format, select Patterns, choose Red, and OK out. Set the Cell
Background to Green, and it will remian green till 80 days after the date in
A1, when it will turn red.

"bikerhd" wrote:

i would like to add 90 days to a date and have it stay green, and trun red on
the 80th day can this be done.
--
cj