Tolerance Formula in Excel

Welcome to the forum. You can do this with Conditional Formatting (CF).

For this example, I will assume you have 'planned %' in column A and 'actual %' in column B, with data starting in row 2. Amend the $B2 and $A2 references in the formulae below to match where your actual data is.

1. Select your range (the range you want to format) - for example B2:B10.
2. On the Home tab of the ribbon, click 'Conditional Formatting', then 'New Rule', then 'Use a formula to determine which cells to format'.
3. In the formula box, enter this:

Formula:

Please Login or Register  to view this content.

4. Click 'Format' then click the 'Fill' tab and choose the green colour you want.
5. Click OK twice to get back to the worksheet.

Repeat from step 3 using these formulae:
For blue:

Formula:

Please Login or Register  to view this content.

For amber:

Formula:

Please Login or Register  to view this content.

For red:

Formula:

Please Login or Register  to view this content.

Hope that helps.