Hi everyone
I've got two values in A1 and B1 that represent limit values. When the user enters a value in C1 I need that cell background to change to red if it is outside A1 and B1 and green if it is in between.
Due to some other code I have to use VBA and not conditional formatting.
Probably an extremely easy question, but I'm terrible with VBA.
I can do all of the logic (there are a few more cases that I can add in later) if I can get the proper code to:
1)run the code when C1 is selected,
2)compare the values
3)and change the background color.
Thanks,
Jordan
Bookmarks