If formula to conditonally format a cell

  • Thread starter Very Basic User
  • Start date
L

Luke M

There are many possibilities, but lets say you want the cell (A2) to turn red
if value is under 0.
select a2, then goto Format-Conditional Format.
Change first box to "formula is". Input
=A2<0
Click format, go to patterns tab, pick red. Hit 'ok'. Hit 'ok'. Cell is now
formatted.
 
Top