cell color to be changed based on priority

[sreejeshc]

Hi

I am having a log sheet where i need to have the cell color changed based on the priority and time duration

Column A will have the date of entry
.
.
.
Column F shall have priority 1, priority2, priority3 as selection.
Default Color for priority 1 is red, priority 2 is yellow and priority 3 is green

If priority 1 is selected, the cell color to be red
If priority 2 is selected, the cell color to be yellow, but after 12 hours from date of entry, the cell color to be changed to red
If priority 3 is selected, the cell color to be green, but after 24 hours from date of entry, cell color to be changed to yellow and after 36hours from date of entry, cell color to be changed to red


regards

 

[Special-K99]

Select Column A

Conditional Formatting
New Rule
Use a formula to determine...

=(F1=1) format as red

=(AND(F1=2,NOW()-A1<=0.5)) format as yellow
=(AND(F1=2,NOW()-A1>0.5)) format as red

=(AND(F1=3,NOW()-A1<=1)) format as green
=(AND(F1=3,NOW()-A1>1)) format as yellow
=(AND(F1=3,NOW()-A1>1.5)) format as red


Format as required
Use Format painter (paintbrush icon) to copy to other cells