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.
I tried playing with IF/OR statements and conditional formatting but couldn't figure out a suitable command.
Thank you.