Conditional formatting question

[Peter]

I'd like to conditionally format an entire row (green font) if the value of
one of its member cells is positive (if it's 'not(isblank)', I guess). I'm
trying to keep track of expenses & income and would like to make it easy to
spot rows that contain income, which will be kept in a column all to itself.
How can I reference the income-containing cell in such as way that all the
other columns "know" about it in the same way and the row formatting can be
copied/pasted to other rows? I hope this isn't too vague a question.

Thanks,

Peter

 

[Andy Brown]

How can I reference the income-containing cell in such as way that all the

other columns "know" about it in the same way and the row formatting can be
copied/pasted to other rows? I hope this isn't too vague a question.

Let's say the "income-containing cell column" is F. Select an entire row,
then use something like

=$F1>0

for "Formula Is". The $ before the letter (but not before the number)
anchors the column reference (but not the row reference).

Rgds,
Andy

 

[Bob Phillips]

Peter,

Select the row (let's say row 1), change condition 1 to Formula Is and add a
formula of
=$H1 >0

set the pattern colour and you are away

If you want ISBLANK, then use

=NOT(ISBLANK($H1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peter]

Let's say the "income-containing cell column" is F. Select an entire
row, then use something like

=$F1>0

for "Formula Is". The $ before the letter (but not before the number)
anchors the column reference (but not the row reference).

Rgds,
Andy

Exactly what I was looking for. Thanks very much.

 

[Peter]

How cool is this newsgroup? Two helpful answers within 5 minutes!

Thanks much.