Conditional Format %

[R1chard]

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.

 

[jtakw]

Hi,

May be this for your A Column CF formula:

=(B1-A1)>b1*.2

 

[Peter_SSs]

Try this CF formula rule.

BTW,
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

21 02 19.xlsm
	A	B
1	10	20
CF 80%

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=A1<=80%*B1	text	NO