Coloring cells of a column condition

[nprashiyer]

Hi,
I'm looking for help in conditional formatting of cell.
If value of a cell is greater than the cell above it then green. Else red.
This rule should be applied across all cells in the column.
Thanks

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A
1	Northing
2	374154
3	378258
4	429632
5	371942
6	373805
7	430517
8	372721
9	358934
10	373922
11	376036
12	376740
13	418077
14	407793
15	430742
16	417000
17	434158
18	428470
19	347917
20	138816
21	524908
22
23
24
25
26
27
28
29
30
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A27	Expression	=AND(A2<>"",A2<N(A1))	text	NO
A2:A27	Expression	=A2>A1	text	NO