I want to make a cell change colour based on a number of different criteria:
Cell A1 Has an incident date
B1 Displays the date 14 days after the incident date.
Cell C1 will have a car make in, Cell D1 has an examined yes or no option. C1 and D1 will always be completed.
However there may be a car in Cell E1, G1, I1, with examined options in cells F1, H1, J1.
I would like cell B1 to be formatted in the following ways:
Less than 2 days from todays date until due date - red fill
3 to 7 days from todays date until due date - orange fill
8 to 14 days from todays date until due date - green fill
But not if D1 is YES (blank or No then must change), and there is nothing entered in E1, G1 I1.
If E1, G1 or I1 have a car entered then the corresponding examined box must be in the same state as described for D1.
Is this possible? if so how please?
I know its a little complicated!