Using Mac 2011 and I am trying to conditionally format a cell's text. IF K5>H5, I want the K5 text to be in RED. I close CLASSIC for style, "Use a formula to determine which cells to format" from the pull-down menu, and CUSTOM FORMAT to choose the color of red I desired. I then entered this formula:

="IF(K5>H5)"

(also tried it without the "" marks)

But no matter what value I have in K5, either < or > H5, it ALWAYS makes the font RED. The formula doesn't generate an error, so it is a correct argument. But why is it always coming out with a red font in every case? What do I need to do to get this formula to work?

TIA.

Rob