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