Conditional formatting based on comparative value

[RodneyW]

I want to compare C20 and C21. These values will change based on several variables.

I need a formula that compares these two values and allows me to change the font color and cell background for the higher of the two.

Within the Conditional Formatting I'd use the "Use Formula to determine which cells to format" and have something in C20 such as =IF >C21

but that doesn't work. Any ideas?

Using Microsoft Professional Plus 2013

Thanks in advance

 

[kevin9999]

Book1
	B	C	D
20
21		0
22		1
23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C22	Expression	=C22>C21	text	YES
C21	Expression	=C21>C22	text	YES

Book1
	B	C	D
20
21		1
22		1
23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C22	Expression	=C22>C21	text	YES
C21	Expression	=C21>C22	text	YES

Book1
	B	C	D
20
21		1
22		0
23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C22	Expression	=C22>C21	text	YES
C21	Expression	=C21>C22	text	YES

 

[Peter_SSs]

change the font color and cell background for the higher of the two.

What if they are equal?

In any case, my preference would be to have a single Conditional Formatting rule to cover both cells.
From what you said above I am assuming the cells contain formulas & I am also assuming those formulas return numerical values. (Please give details if the assumptions are incorrect)

In the mini sheet below I have given two options.
The CF in column C would format both cells if they are equal.
The CF in column E would format neither cell if they are equal.

25 01 19.xlsm
	C	D	E
19
20	13		16
21	28		1
22
CF Max

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E20:E21	Expression	=E20<>LARGE(E$20:E$21,2)	text	NO
C20:C21	Expression	=C20=MAX(C$20:C$21)	text	NO

 

[RodneyW]

Book1
	B	C	D
20
21		0
22		1
23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C22	Expression	=C22>C21	text	YES
C21	Expression	=C21>C22	text	YES

Book1
	B	C	D
20
21		1
22		1
23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C22	Expression	=C22>C21	text	YES
C21	Expression	=C21>C22	text	YES

Book1
	B	C	D
20
21		1
22		0
23
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C22	Expression	=C22>C21	text	YES
C21	Expression	=C21>C22	text	YES

Kevin, thank you. It worked perfectly. Peter, I tried Kevin's before I saw yours. To answer your question, the two numbers will never be equal. Thanks for your input as well.

 

[kevin9999]

Kevin, thank you. It worked perfectly. Peter, I tried Kevin's before I saw yours. To answer your question, the two numbers will never be equal. Thanks for your input as well.

Glad we could help Rodney