Posted on

Conditional Formatting

Excel Formulas

Used as part of conditional formatting.

IF F2 is (<,>,=) H2 then colour cell as defined in conditional formatting.

=IF(F2>H2,TRUE,FALSE)
=IF(F2<H2,TRUE,FALSE)
=IF(F2=H2,TRUE,FALSE)