Change cell color based upon date entries in varioius cells
IFC test book for 09292011.xlsxI need help. I have
been working on this for two days, but cannot get the right solution. I have a spreadsheet that I need to have several cells
and rows turn colors.
First, I need a cell that has a date entered to change colors when the next cell is entered
and is 6 days or greater than the entry date.
Second, once this color changes take place, the entry date should
remain as is.
Third, I need the 6 days or greater cell change colors when a scheduled service date is entered.
Fourth, I need to have the scheduled service date change color when a performed date is entered.
Finally, when a discontinued date is entered, I need the whole row to change color showing this service has been completed.
I have tried using conditional formatting and cannot seem to get it to work. Please I need help so that I can go
on to the next part of the process that I am doing with this spreadsheet.
I have attached a copy of a file similar
to what I have created.
Thanks to everyone who will helps me solve my problem.