Simple question. I failed with the search function
I am wanting a cell to become highlighted, if its value is 20% less than another cell
Example:
A1=10 (not highlighted)
B1=11
A1=10 (highlighted)
B1=20
A1 value stays static. B1 value is always changing. If A1 = 20% less than B1 I want that cell to highlight.
I am wanting a cell to become highlighted, if its value is 20% less than another cell
Example:
A1=10 (not highlighted)
B1=11
A1=10 (highlighted)
B1=20
A1 value stays static. B1 value is always changing. If A1 = 20% less than B1 I want that cell to highlight.