Conditional formatting.

Select all the cells, FormatConditional Formatting, then set the conditions
and format.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dylan" wrote in message
oups.com...
Hi,

I want to colour code my fields in a truth table, i.e red if false and
green if true.

What's the easiest way to do this?

Thanks in advance,

Dylan