Change cell color based on two values

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

Hi there,

Your description is vague.

Could you provide more details? Or maybe an example attached?

I've got values in A1 and B1.

When a value is entered in C1, the background of that cell needs to change to green if it is between A1 and B1. If the value is outside those two values it needs to change to red.

As I said, I can't use conditional formatting for this because of some other code that references C1.

Between A1 and B1 meaning A1 can be < B1 and B1 can be < than A1?

And by outside of those two values do you mean not equal to those values or more than those values?

A1 will always be less than B1.

I guess if C1 is equal to the limits I'll call it inside. C1 will always be a very precise value. We've never had it come up before.

There:

Please Login or Register  to view this content.