Kevin McNemar
Occasional Contributor

I already have a cell setup to change color according to certain dates how can i link other cells to this cell so they will change to the same color

2 Replies
try: on that cell press Ctrl C then paste special to desired cells "Formats"..

Hi @Kevin McNemar


Have you tried using Format Painter to the cells you want to copy the Conditional Formatting to?


  1. Click onto a cell with the format you want.
  2. In your Home tab, click into Format Painter.
  3. Select the cell/s that you want to have the Conditional Formatting on. This will apply the formatting to those cells.


Hope that is what you are after? 


Cheers and best wishes Damien