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.
