Copying Conditional Formatting Down A Column

[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

 

[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

 

[SamuelT]

Hi there,

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

Thanks anyhow,

Samuel

 

[swatsp0p]

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

More details, please

 

[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

 

[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

 

[SamuelT]

Brilliant. You are a genius! That's working a treat.

Many thanks,

SamuelT

 

[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

 

[swatsp0p]

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

Cheers!