Copying Conditional Formatting

C

Cindy

I have two columns that should have the same number in
the same row. ie: a1 should equal a2; b1 should equal
b2 etc.

I have b1 as a conditional format to be bold and red if
it does not equal a1. I would like to copy this to other
cells but the conditional formatting seems to lock the
cell you refer to. ie: $A$1.

What I would like it to do, is when I copy the cell is to
change a1 to a2 etc., like a normal copy comand.

Is there a way to do this? Any help would be appreciated.

Thanks.
 
M

macropod

Hi Cindy,

Simply edit the conditional format formula by taking out the '$' symbols.
That makes the formula relative, and when the format is copied to a new
cell, the references will update.

Cheers
 

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

Similar Threads

Conditional Formatting Driving Me Crazy 1
Apply Conditional Formatting to other rows 6
Conditional Formatting Help 1
Copy conditional formatting across column in the same row 2
Comparison of columns using Conditional Formatting 3
Conditional Formatting 1
conditional Formatting cell wildcard 3
Conditional formatting referencing date of expiration 5

Top