Hi guys, I'm trying to write a macros where it changes the value of one column based on the input condition of the user.

For example:

InputBox A = 0.5
InputBox B = 1.0

Check the entire column A, if value of column A is >= 0.5 AND value of column A is <= 1.0, Then change Column B value to 1. If NOT, Do NOTHING.

Greatly appreciate your experts help.