Hi All,
What procedure would i need to use to achieve the following
Sheet1 has 300 cells which all use a drop down box which can display either a A or B from the list...If A or B are not selected the cell remains empty....
1. How can i on Sheet2 in the same 300 cells as Sheet1 have a colour displayed depending on whether A , B or Empty Cell are selected on Sheet1....If A from drop down box list is selected on Sheet1 in cell A3 what formulas would i use in Sheet2 to display a Blue Coloured A3 Cell.If B is used on Sheet1 in cell A3 again how do i display the colour Yellow in the Sheet2 cell A3 and finally if neither A and B are selected in Sheet1 the same numbered cell in Sheet2 remains empty (white)
Much appreciated
Tborland
What procedure would i need to use to achieve the following
Sheet1 has 300 cells which all use a drop down box which can display either a A or B from the list...If A or B are not selected the cell remains empty....
1. How can i on Sheet2 in the same 300 cells as Sheet1 have a colour displayed depending on whether A , B or Empty Cell are selected on Sheet1....If A from drop down box list is selected on Sheet1 in cell A3 what formulas would i use in Sheet2 to display a Blue Coloured A3 Cell.If B is used on Sheet1 in cell A3 again how do i display the colour Yellow in the Sheet2 cell A3 and finally if neither A and B are selected in Sheet1 the same numbered cell in Sheet2 remains empty (white)
Much appreciated
Tborland