Conditional formatting

[JimS]

I seem to have problems writing formulas for conditional formatting.

H J K

5 98 103

I want to write a rule such that if K117 is greater than j117 and
also if H 117>0, then the cell turns yellow or whatever. Can't get it
to work.

Thanks

 

[muddan madhu]

=AND(K117>J117,H117>0)

 

[JimS]

Thanks, much appreciated.

=AND(K117>J117,H117>0)

 

[herochenna]

Visit www.ExcelGoodies.Com