Color formatting based on cell value difference

[MarioCald]

I would like to enter a number (InputNumber) and then if the value (Value) is within -/+ 1 (0.0 to 1.0), color the value row green. If the value (Value) is within -/+ 1 to -/+ 1.5 (1.01 to 1.50), color the value row yellow. If the difference is greater then 1.5, don't do anything.

I tried playing with IF/OR statements and conditional formatting but couldn't figure out a suitable command.

Thank you.

 

[bbotzong]

Select the entire range to be formatted (i.e., A3:B7 in your picture). You will need two conditional formats.

For the first, select Use a formula to determine which cells to format. Enter the formula =ABS($B$1-$B3)<=1 and select the green fill color.
For the second, select same conditional format choice, and enter formula =AND(ABS($B$1-$B3)>1,ABS($B$1-$B3)<=1.5)+

Hope this helps.

Bill B.

 

[MarioCald]

Perfect! Thank you.