I have a spreadsheet that has a list of 200 customers, I would like to use
the end date of the customers renewal section then subtract it from the
current date and if that is less than 130 days I want the cell that has the
customers name in it to turn yellow. Can this be done and how?
--
Thanks in advance

Neall

Try using the conditional format. Goto <format, then <conditional
formatting.

"cell value is", drop down to "less than", enter 130, goto <format pick
your pattern

"Neall" wrote:

I have a spreadsheet that has a list of 200 customers, I would like to use
the end date of the customers renewal section then subtract it from the
current date and if that is less than 130 days I want the cell that has the
customers name in it to turn yellow. Can this be done and how?
--
Thanks in advance

Neall

It looks like it might work however if Cell 1A is the customers name and Cell
1D is the date (07/07/2007) how do I subtract 130 (days) from the date type
in 1D and make 1A change color

Thanks in advance
--
Neall


"JVANWORTH" wrote:

Try using the conditional format. Goto <format, then <conditional
formatting.

"cell value is", drop down to "less than", enter 130, goto <format pick
your pattern

"Neall" wrote:

I have a spreadsheet that has a list of 200 customers, I would like to use
the end date of the customers renewal section then subtract it from the
current date and if that is less than 130 days I want the cell that has the
customers name in it to turn yellow. Can this be done and how?
--
Thanks in advance

Neall

try this-

highlight the customer name, goto back to conditional formatting, drop down
to "formula is" (instead of "cell value is") use
=if(1D130,true,false)

it should work

"Neall" wrote:

It looks like it might work however if Cell 1A is the customers name and Cell
1D is the date (07/07/2007) how do I subtract 130 (days) from the date type
in 1D and make 1A change color

Thanks in advance
--
Neall


"JVANWORTH" wrote:

Try using the conditional format. Goto <format, then <conditional
formatting.

"cell value is", drop down to "less than", enter 130, goto <format pick
your pattern

"Neall" wrote:

I have a spreadsheet that has a list of 200 customers, I would like to use
the end date of the customers renewal section then subtract it from the
current date and if that is less than 130 days I want the cell that has the
customers name in it to turn yellow. Can this be done and how?
--
Thanks in advance

Neall