update the cell with formatting
Hello,
I am in a situation where all my cells on one worksheet(say 2) are
updated according to the cells in other worksheet (say 1).
Though all the formulas in 2 are calculated with the values in 1. I
also need to update it based ont he formatting of the cell in 1.
If cell in 1 has a red fill in color, the corresponding cell in 2
should also get updated to red fill-in color.
Is there a way it can be done?
Thanks,
Aby Mathew
|