Change color of cell comparing contents to 2 cells

Closed
sjohn - 16 Mar 2018 à 07:27
sjohn8220 Posts 1 Registration date Friday 16 March 2018 Status Member Last seen 16 March 2018 - 16 Mar 2018 à 07:52
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)

Related:

1 response

sjohn8220 Posts 1 Registration date Friday 16 March 2018 Status Member Last seen 16 March 2018
16 Mar 2018 à 07:52
I am using Excel 2013. Thanks again.