Hi,
using conditional formating I want to highlight in one column cells that meet a condition using values from a different column.
I have the following formula 
=IF($K:$K>50000,1,0)
but I cannot get it to work...
Can someone please give me some help..
Thanks
legepe