Change color of cell comparing contents to 2 cells

Closed
sjohn - Mar 16, 2018 at 07:27 AM
sjohn8220 Posts 1 Registration date Friday March 16, 2018 Status Member Last seen March 16, 2018 - Mar 16, 2018 at 07:52 AM
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 March 16, 2018 Status Member Last seen March 16, 2018
Mar 16, 2018 at 07:52 AM
I am using Excel 2013. Thanks again.
0