brayleyboy
Board Regular
- Joined
- Nov 24, 2005
- Messages
- 52
Hi, I have a formatting problem. I have created drop down list using data validation. I would like the cell to format to different fill colours depending on the option chosen. I have acheived this using conditional formatting. However my dropdown lists contains 5 options, and conditional formatting only allows 3. Is there another way of doing this?
Thanks
Thanks