Setting a cell colour based on another cells colour

[blanch80]

Hi,

I'm hoping someone can help me with my problem.

I have four cells, A1, B1, C1, D1. i enter values in A1 & B1 which are summed in C1 and depending on the result conditional formatting will set the colour of the cell (C1).

Then D1 reared it's ugly head. I need cell D1 to contain no value, but change to the same colour as C1 - and if the values in A1, B1 change and C1's fill colour changes - for D1 to also change.

I'm guessing it will have to be done through VBA, and am hoping someone might be able to help as it's not my strongest point.

Thanks,
David.

 

[VoG]

Can't you use the same CF in D1 as C1. Or use a CF formula like

=C1>10

for example.

 

[Peter_SSs]

Hi,

I'm hoping someone can help me with my problem.

I have four cells, A1, B1, C1, D1. i enter values in A1 & B1 which are summed in C1 and depending on the result conditional formatting will set the colour of the cell (C1).

Then D1 reared it's ugly head. I need cell D1 to contain no value, but change to the same colour as C1 - and if the values in A1, B1 change and C1's fill colour changes - for D1 to also change.

I'm guessing it will have to be done through VBA, and am hoping someone might be able to help as it's not my strongest point.

Thanks,
David.

Welcome to MrExcel!

If I have understood correctly, you should not need vba, just apply exactly the same Conditional Formatting to D1 as you have to C1.

 

[blanch80]

Sorry - it's me being a tool.

Thank you!

 

[Peter_SSs]

Sorry - it's me being a tool.

It happens.

 

[blanch80]

It happens.

- it wasn't quite what i wanted as i need D1 to appear blank - but i managed this by setting the cell type to Custom then using the 3 semicolons trick.

 

[Peter_SSs]

What do you actually have in D1? If a formula, what formula?

What is the Conditional Formatting rule in C1?