Complex Conditional format question

[Louise_douglass]

Trying to replace a macro for a conditional format.

Can I use conditional formatting when I have a cell that is coloured - for eg. Cell BN30 is coloured in pink. IF that cell has a colour - I want that same colour to populate in cell BZ30. Is this possible?

hope I explained well enough!!

Thanks!

 

[anglais428]

You should use the same formula you use for the first cell but on the second cell

 

[Louise_douglass]

I am not sure I understand?

The first cell is colour formatted manually. Instead of running a macro I want to know whether we can get that second cell to auto format to the same. so if I decide to make the cell BN30 Blue - it will format Cell BZ30 to blue as well.

thanks!

 

[Louise_douglass]

Is anyone able to help with this request?

Basically I am looking for the right function in excel to colour a cell automatically in the SAME colour IF another cell has been populated in that colour. SO in A1 is coloured blue B1 will colour in Blue as well!

Thanks a bunch!!!

 

[Special-K99]

You can only detect cell colour using VBA.

 

[Louise_douglass]

what would be the best way if I was using VBA?

 

[Special-K99]

This seems to work (am no VBA expert)

Sub k1()
CellClr = Range("A1").Interior.Color
Debug.Print CellClr
End Sub

CellClr returns a numeric value based on colour

 

[anglais428]

Say your formula for conditional formatting for cell BN30 is ">5". If the cell value is greater than 5 color it pink.
For BZ30 then just apply the formula (in conditional formatting) '=BN30>5' and condition it to turn pink also.