Highlight cells that have a more or less percentage of the row average - per row

[Petrus]

Hello,
I have a list of data values in rows with an average of each row.
Is there a way that excel can show me all the cells per row that have a higher than 15 percent value of the average of that row in red?
And also all the cells per row that have a 10 percent or less value of the average of that row in yellow?

Thank you for the help

 

[etaf]

use as rules
=B2>=AVERAGE($B2:$E2)*1.15
and
=B2<=AVERAGE($B2:$E2)*0.9

 

[Petrus]

use as rules
=B2>=AVERAGE($B2:$E2)*1.15
and
=B2<=AVERAGE($B2:$E2)*0.9

Thanks
How do I add those rules?

 

[etaf]

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
B2:E100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=B2>=AVERAGE($B2:$E2)*1.15

Format [Number, Font, Border, Fill] - FILL RED
choose the format you would like to apply when the condition is true
OK >> OK

REPEAT for Yellow Fill rule