Copying Conditional Formatting Down A Column

S

SamuelT

Hi all,

I'm trying to copy some conditional formatting down a column. Problem
is, I want it to be specific to the row it's on. However, at the
moment, all it does is copy the same row reference all the way down the
column.

Is there a means to rectify this - as if I was dragging a formula down
the column?

Thanks in advance,

SamuelT
 
S

swatsp0p

You don't list the formula in your CF, so I can only guess that you ma
have an absolute reference (e.g. $A$1). Remove the '$' to make i
relative and it will automatically change as you copy the CF.

Good luc
 
S

SamuelT

Hi there,

No, the cell reference is relative. It's something to do wit
conditional formatting.

Thanks anyhow,

Samuel
 
S

swatsp0p

Could you post the conditon(s) you have in your CF? It may better hel
us to solve your problem.

More details, please
 
S

SamuelT

The formula was:

IF(AND(EV2="Yes",EY2<0) then I want the cell to go red.

As stated though, when I copy this formatting down it always refers to
EV2 and EY2, as opposed, for example to EV50 and EY50.

Hope that helps.

Thanks!

SamuelT
 
S

swatsp0p

First, try rewriting your formula as:

=AND(EV2="Yes",EY2<0) (the IF is not needed)

Then try Copy>Paste Special>Formats

This works for me
 
M

Max

It should work .. Perhaps try again ?

Supposing the CF formula below is currently applied to say, cell FA2
=AND(EV2="Yes",EY2<0)

Just select FA2, click Format Painter and "paint" down the col

The CF formulas would adjust relatively for the rows,
i.e. in FA3, it'll become: =AND(EV3="Yes",EY3<0), and so on
 
S

swatsp0p

I'm glad it worked for you. Thanks for the feedback, it is always
appreciated.

Cheers!
 
Top