Hi Everyone,
please guide me to my weird requirement. (Office 2010)
Let say i have a workbook containing 2 sheets, Sheet 1 & Sheet 2.
i need a group of cells on Sheet 2 to change colors, if value of Sheet1!A1 changes.
Basically am trying to color those cells to select color name on Sheet 1.
If Sheet1!A1 = Blue, then Cells on Sheet 2 to turn-up Blue.
If Sheet1!A1 = Red, then Cells on Sheet 2 to turn-up Red.
and so on
please help.
Bookmarks