muttley132
New Member
- Joined
- Nov 24, 2009
- Messages
- 2
Hi people,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
i have a spread sheet with "pick from list" boxes, but i want to add a colour to the box automatically depending on the item that as been picked.<o></o>
<o> </o>
So, cell 1,A, I pick a persons name, I want the background of that cell in red.<o></o>
cell 2,A, another persons name, in another colour.<o></o>
<o> </o>
Any ideas how or if this can be done, and how easy is it.<o></o>
<o> </o>
Thanks in advance.<o></o>
i have a spread sheet with "pick from list" boxes, but i want to add a colour to the box automatically depending on the item that as been picked.<o></o>
<o> </o>
So, cell 1,A, I pick a persons name, I want the background of that cell in red.<o></o>
cell 2,A, another persons name, in another colour.<o></o>
<o> </o>
Any ideas how or if this can be done, and how easy is it.<o></o>
<o> </o>
Thanks in advance.<o></o>