Compare column values fill color individually

[cubeincube]

Hi,
I need this(kinda an example):
compare A1 value to B1, if A1 is bigger, then fill B1 with color Red. also compare A1 with C1, if A1 is smaller than C1 then fill C1 with color Green and compare A1 to D1 and let's say if D1 is bigger then fill D1 with color Blue.(all numbers)
then expand this, to the whole sheet.(All rows with four columns)
couldn't find an easy way to do this by conditional formatting.
thanks

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A	B	C	D
1	88	70	51	92
2	98	99	77	95
3	87	92	78	98
4	93	65	95	87
5	51	78	93	98
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D1:D5	Expression	=$A1<$D1	text	NO
C1:C5	Expression	=$A1<$C1	text	NO
B1:B5	Expression	=$A1>$B1	text	NO

 

[cubeincube]

Thank you Fluff!
That's exactly it.

Thank you?

 

[Fluff]

You're welcome & thanks for the feedback.