Mirror cell including highlight color

[Konisegg]

Hi everyone, 

I'm learning Excel as I go so not a huge knowledge yet, but hoping someone can help with this. I am trying to mirror a cell in a way that when I change the text and highlight color of the referenced cell the mirrored cell changes as well. 

Eg. I want so that I can assign A column cells to B & C cells. Then when I change the color in the A cells it matches exactly in the mirrored cell. So in the picture below, changing cell A3 to green would also Change B3 to green. 

I know that was a long explanation but hard to describe without examples. 

Thanks

[#2 · Accepted solution]

@Konisegg 

Use conditional formatting to highlight information

You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.

Highlight patterns and trends with conditional formatting

You can format a whole cell range and vary the exact format as the value of each cell varies.

Hope I was able to help you with this information.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

@NikolinoDE thanks for the reply. 

I understand how to use conditional formatting for a specified range but none of these ways describe how to mirror another cell.

I want to exactly mirror cell A1 to cell C1 so that anytime I change the text or highlight color of A1, the changes will automatically happen to C1. That way I am only updating one cell, but all the others mirroring it will change as well. 

[#4]

@Konisegg 

With VBA I can only help out here.

It's the easiest and fastest:).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheets("Tabelle1").Range("A1").Copy Destination:=Sheets("Tabelle1").Range("C5")
End Sub

 In the attached file the example

Hope I was able to help you with this information.

NikolinoDE

I know I don't know anything (Socrates)