Conditional formatting

[jarhead58]

I thought this was pretty straight forward but I guess not. I have a cell that I want to alternate colors between green and red depending on another cell being > or < a third cell. For example I want A7 green if B8>=A8 and red if B8<A8. I've tried the Formula Rule Type with A7 highlighted, $B$8>=$A$8 then format fill green and a second rule with $B$8<$A$8 then format fill green but it doesn't work. It always stays green in each criteria.

 

[NateSC]

temp macro work2.xlsm
	A	B
7
8	10	9
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A7	Expression	=$B$8<$A$8	text	NO
A7	Expression	=$B$8>=$A$8	text	NO

 

[NateSC]

There is a seemingly extra = at the beginning of the equation, but it is necessary.

 

[jarhead58]

There is a seemingly extra = at the beginning of the equation, but it is necessary.

That was it, simple as that. lol Appreciate the help NateSC. Is that SC South Carolina?

 

[NateSC]

Glad to help. I've gotten stumped by this exact thing before. And, yes, it is South Carolina.

 

[jarhead58]

Glad to help. I've gotten stumped by this exact thing before. And, yes, it is South Carolina.

Same here!