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 A30 and A1=Jared then format A3 to be bold and red.

Thanks,

Jared

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

--

HTH

Bob Phillips

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

"Jared" wrote in message
...
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 A30 and A1=Jared then format A3 to be bold and red.

Thanks,

Jared