Re. Conditional formating of adjacent cells but down a column

Joined
Feb 16, 2012
Messages
1
Reaction score
0
Hello

Hope you can help

I want to colour say, C1 if A1 OR B1 > 0

I want to however repeat this down the column so ...

C2 is coloured if A2 or B2 > 0
C3 is coloured if A3 or B3 > 0

I can do it for one row, but can't work out the formula for it to apply to the whole column

When I do it, either nothing happens or each cell in column C focuses on just A1 and B1 instead of the corresponding cells in column A or B

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top