Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shade under a line | Charts and Charting in Excel |