Hi there,

I have an excel workbook with two tabs. One tab has certain cells highlighted in red. I would like the second tab same cells also highlighted in red. When the cell in the first tab changes color, I would like to have the second tab the same cell change color as well (color index are the same in both tabs).

Would appreciate if someone can help me on the VBA coding to this.

Thanks,

Susanliu