Format cell based on adjacent cell / apply to column

[mknispel]

Good day everyone, I am trying to apply color coding to cells within a column based on the content in the adjoining cell.

Basically, if the cells under the header "Actual Runtime" are -3 of the value in the adjoining cell under the header "Sched Runtime" then the cell turns yellow.
If the cells under the header "Actual Runtime" are +3 of the value in the adjoining cell under the header "Sched Runtime" then the cell turns Red.
If the cells under the header "Actual Runtime" are within -3 - +3 of the value in the adjoining cell under the header "Sched Runtime" then the cell turns green.

I was able to create this on a cell by cell basis. However, I have multiple workbooks, and I would like a more effective and efficent way to apply this formatting.

I am attaching the workbook for clarification purposes

Thank you in advance of any assistance you may offer.

[NBVC]

Select the Actual Runtime ranges starting from C6, then go to Home|Conditional Formatting, New Rule

Use a formula to determine which cells to format, then enter formula:

=C6=D6-3

click Format, choose Yellow

click Ok,

Click New Rule, repeat above with

=C6=D6+3 and Red

repeat again with

=AND(C6>D6-3,C6<D6+3) and Green

[mknispel]

Didn't work. Any other suggestions.

[NBVC]

Is this what you are looking for?