Mirror cell including highlight color

New Contributor

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. 


Screen Shot 2022-03-03 at 9.13.54 PM.jpg


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




3 Replies
best response confirmed by Konisegg (New Contributor)


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.



I know I don't know anything (Socrates)

@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. 


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.



I know I don't know anything (Socrates)