Formatting Question

[Jared]

If I have a cell or group of cells that I want to show up in red if they are
greater than zero, for example, and another cell is a certain value how do I
do this. I've looked at the conditional formatting option but I can't see how
it will help here.

Here's an example of using cell references of what I'm trying to do.

If A3>0 and A1=Jared then format A3 to be bold and red.

Thanks,

Jared

 

[Bob Phillips]

In CF, change Condition 1 to Formula Is, and add a formula of
=AND(A3>0,A1="Jared") and select a pattern colour.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)