Looking to add color code alert
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
|