Select Q7 and FormatConditional FormattingFormula is

=$Q6<0

Format to red and OK


Gord

On Fri, 24 Feb 2012 06:08:30 -0800 (PST), pcorcele
wrote:

How do I go about telling cell q7 backgound to be RED when q6 cell is
less that zero
Thanks