You can do this with Format | Conditional Formatting. You specify the
condition and choose the format you want for the cell - you can have up
to 3 conditional formats by clicking Add (plus you also have the
"normal" format), so this will cope with what you want to do.

Pete