Pasting a block w/o needing to update conditional formats...

[spacely]

Hello,

I need to make values in column B and C bold if the corresponding entry in column A is a "1". So a 1 in A makes B and C bold, for every row where that's true.

The conditional format is using a formula, like:

=$AS11=1

and applies to column B and C, like $B:$C

The thing is, I need to copy the blocks to column M, N, O, and have the conditional formats still working w/o editing them. So now, N and O would become bold if the entry in M is a 1.

I tried removing the $ from the Formula portion, but that doesn't seem to work.

What's the right way to get the same type formatting over to the new columns with just a copy/paste?

 

[jmacleary]

Hi there.

You will need to set what looks like the same rule separately for columns B and C. Use: =A1=1 for column B and the same formula for column C. Then when you copy A,B,C to M,N,O the relative references in N and O will refer to column M. Make sure you remove all the existing conditional formatting first (after saving a backup).