change style based on higher, lower or equal to another - conditional formatting the solution?

[pook_666]

Hi there,

I have the below example of a table. What I want to do is compare each products price and change the style of the cell in column C to good if higher than column B, neutral if the same and bad if lower.

So in the end I want to have the below. Is there anyway I can do a conditional format to do this automatically instead of just manually comparing? (currently have data 100's row long, so trying to avoid doing it manually!!!)

 

[Alex Blakenburg]

I couldn't get your colors but is this what you had in mind ?

20210331 Conditional Formatting.xlsx
	A	B	C	D
1
2		1	3
3		3	1
4		4	4
5		5	4
6		9	9
7		1	3
8		3	5
9		6	2
10
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:C9	Expression	=C2>B2	text	YES
C2:C9	Expression	=C2=B2	text	YES
C2:C9	Expression	=C2<B2	text	NO

 

[pook_666]

Yes, this is it......what option is this within conditional formatting?