conditional formatting

[Bhagya07]

column'e'
23
24
25
26
27
28
n/f
30

cells(70,3) = 25
i want to change the color of column'e' values to green if cells(70,3)>column'e' if value is text color should not change

 

[GopalaKrishnaJ]

Try this conditional formatting and give color as green

=IF(AND(ISNUMBER(E1),E1>$C$70),TRUE,FALSE)