Forum Discussion

Konisegg's avatar
Konisegg
Copper Contributor
Mar 03, 2022
Solved

Mirror cell including highlight color

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

 

excel
Formulas and Functions

4 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Mar 05, 2022

    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)

    • Konisegg's avatar
      Konisegg
      Copper Contributor
      Mar 05, 2022

      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. 

      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor
        Mar 05, 2022

        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)

Resources