Conditional formatting

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

=AND(K117>J117,H117>0)


On Nov 15, 4:36 pm, JimS wrote:
> 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