Conditional Formatting based on percentage differences

My table example is quite simple but drawn from percentages. I am not working with raw numbers.

Column A = demographics; Column B = This Year (format as %); Column C = Last Year (format as %)


I would like to apply a conditional format to values in the B column when the value is more than, less than or equal to 4% different to the value in the C column.

I would like to change the fill colour of Column B value to orange when the condition is met. In the example, this would change B3 and B4 as the difference between the cells is 5% higher (B3 and C3) and 7% lower (B4 and C4).

Can anyone help?

I followed your guidance which did indeed work on B4 where the difference was 7% less but did not change B3 which was 5% greater.
However, I applied the logic of a new rule where the formula was

Code:
---------
=ABS($C1-$B1)<=0.04
---------

Is this too simplistic? Thanks for your prompt reply.

No, but that has corrected and now works.

Thanks

Thanks JeteMc for your replies.

You answered the question about how to apply a conditional format when there was a 4% or higher statistical difference.

I have updated my spreadsheet with variable data where again I would like to highlight the cell in column b (this is on a different sheet) if the percentage difference is greater than or equal to 4%.

Some rows where the difference is higher are positive and some are negative and my only reference to these is in column D where I have added "HG" - higher difference is good or "HB" - higher difference is bad.

Is it possible to advise what formula could be created for this column to manage both situations?

Hi again JeteMc,
I really do appreciate your help, however some cells are not formatting correctly.
I have attached the sample file and added further data. In column F, I have added narrative where the conditional format works and where it does not.

In your rules, you specify that the format change takes place if column D = either HB or HG and then the rule if the difference is greater than or equal to 4%. I want the Conditional Format to check if the difference is greater than or equal to 4% and apply the other rules or if less than 4% to leave the format unchanged. Hope this makes sense,

Kind regards

Thanks JeteMc - that worked as I wanted it to.

Much appreciated.

Ady