I move the ActiveCell around using Offset commands. How would I evaluate the ActiveCell and a variable (MyValue), so it can highlight the cell a color?
Compare ActiveCell and MyValue:
Need to figure out the percentage difference between the ActiveCell and MyValue, if it is higher or lower? So if ActiveCell is 100 and MyValue is 90, ActiveCell is 10% higher (or yellow based on color rules below)
To add the color to the cell based on the percent?
If ActiveCell is >15% of MyValue = Red
If ActiveCell is between 10% of MyValue but <15% of MyValue = Yellow
If ActiveCell is under 10% but not lower than -10% = Green
If ActiveCell is -10% or lower = Light blue
Then I move to a different ActiveCell and check that one. Need some help writing this vba to color my cells.
Please advise and thanks