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