I have a range of cells with dates in and then a conditional format to change the colour if criteria is met.
I then have a another group of cells that pulls through the text data from the matching rows for above. So I know I cannot use the same conditional formatting as one cell is dates and the other is correspondent data in text.
So question is if the first group of cells turn blue, say. I want the second group of cells to change to the same colour.
Is there a simple way of just mirroring cells colour?
Bookmarks