Conditional Format Copying

[benjuk]

Hey guys, first post here and plan to be pretty active as I have some huge projects coming up but I'm stuck on what I feel has a simple solution. I have looked for a similar problem but couldn't find it. Here is an example:

A1: Plain text
A2: Number
A3: Plain text
A4: Plain text
A5: Number

I have conditionally formatted A5 so that the cell colour changes if its greater than or less than A2. However I want A1-A4 to replicate the formatting of A5. So for example when A5 turns green, I want them all to turn green. Then when A5 turns red, well, you can guess what I want it to do.

Any help would be much appreciated!

Thankyou

[etaf]

in your formatting
set up a formula

and use $
not sure what formula you are using
and what condition for greater or less

lets assume you have two rules

A2<A5 = green
A2>A5 = red

then change the formula to

$A2<$A5 = green
$A2>$A5 = red

and then apply to the range

A1:A5

Make sure the formula does not change to
="$A2>$A5"
or that the row numbers do not change

upload a sample and we can adjust for you
OR
provide the rules for the red/green and we can do also

[benjuk]

Hi, first of all thanks for your reply! I don't quite understand what you mean though.

I've attached a sample.

Essentially if A5 is equal to or less than A1 then it turns green and if it's more than A1 it will turn red. I want A1 to A4 to replicate the cell colour based on the formatting of A5 if that makes sense.

Thanks

Book.xls

[etaf]

OK so formula in cond format
$A$5<=$A$1 green
$A$5>$A$1 red

and apply to $A$1 to $A$5

see attached

[benjuk]

Perfect. Thankyou very much!