Change color of cell comparing contents to 2 cells

Closed
Report
-
Posts
1
Registration date
Friday March 16, 2018
Status
Member
Last seen
March 16, 2018
-
Hello,

Hope someone in this community can help me write a vba code to for example:
Cells B3 and C3 have a value
When I input values into cells range from D3 to Z3
If D3 >= B3 and/or <=C3 then change color to GREEN
If D3 < B3 and/or > C3 change color to RED
Next cell (E3)

1 reply

Posts
1
Registration date
Friday March 16, 2018
Status
Member
Last seen
March 16, 2018

I am using Excel 2013. Thanks again.