Conditional formatting for variance column

[erisaaka]

I've uploaded the document that I am working with.

First, I need to highlight in red the variances that are greater than 10% of the budget.

Second, I need to highlight in green the variances that are less than 10% of the budget.

Putting a formula into a conditional formatting is new to me. Thanks for the help in advance.

FYI, I want to learn how to do it, so please don't just do it. Instruction would be very helpful.

Book1.xlsx

[benishiryo]

hi erissaka. select the range you want to apply to (say from C2:C31)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=C2/B2>10%
format red

repeat the steps but do this formula for green:
=C2/B2<-10%

if you want to highlight the row where it happens, then select A2:C31 & do the formula with a dollar sign in front of the alphabets. for eg, red is:
=$C2/$B2>10%