Forum Discussion
Excel
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
- try: on that cell press Ctrl C then paste special to desired cells "Formats"..
Have you tried using Format Painter to the cells you want to copy the Conditional Formatting to?
- Click onto a cell with the format you want.
- In your Home tab, click into Format Painter.
- 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
