Conditional Formatting

[holo_9]

Hi Everyone,

Very new to excel and I would like some help possibly formatting an excel sheet at work.
I want to highlight some data to make it easier to present downfalls and highlight successes.
Preferably I want to highlight data that is within 5% of goal. Leave data unchanged that is from 5%-10% of goal. Lastly highlight data red when it is 10% or more from the goal. Below is a snapshot of data with cell numbers.

Thanks for the help

 

[SanjayGMusafir]

First of All, @holo_9 Welcome to the Forum!

Assuming that the goals are in Column A,
Quarters from Column B to Column E for Conditional Formatting

Use following formulae for CF, for 2 different rules. Try and revert -

Remember To use $ Sign exactly as given in formulae below.

I want to highlight data that is within 5% of goal

=B1>=$A1*95%

Lastly highlight data red when it is 10% or more from the goal.

=B1<=$A1*90%