Excel - Conditional formatting

[Jools23]

Hi all,

I am hoping someone can help me before I lose the will to live I have a spreadsheet where i am trying to compare stationary costs between 2 suppliers, i have 2 columns with the values entered for each product but would like to have a cell highlighted in green for example if less than the price in the other cell and red if greater.
I have tried to create a new rule with range of cells but i believe I may be going wrong in the formula I am entering!
Does anyone have a formula that could result in the formatting i require?
Many thanks in advance.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C
1
2	BA2 7PB	44	62
3	DE24 8UT	56	52
4	SE18 5NA	59	63
5	NN3 3EA	13	42
6	SG6 3JZ	61	41
7	OX12 9DJ	48	62
8	YO12 7JB	68	43
9	TS7 0NP	53	53
10	S75 3EB	49	72
11	GL6 8AL	56	57
12	ME9 9LR	62	49
13	TR1 3PN	73	47
14	NW2 7JA	66	45
15	UB8 2EB	48	80
16	WS1 4SE	18	33
17	WS15 3LR	24	12
18	DL6 1PS	76	76
19	BB2 3RE	21	58
20	CA14 2BZ	22	28
21	E4 7EA	64	67
22
Main

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

 

[Jools23]

Hi,

Thank you so much for your speedy reply, very much appreciated.

I will give this a try now and let you know how I get on.

 

[kvsrinivasamurthy]

Data range is B3:C7. Select range. Home tab --> Conditional formatting ---> New rule
Formula for red
=B3=MAX($B3:$C3)

Formula for Green
=B3=MIN($B3:$C3)

 

[Fluff]

Ok,