Another question:
Is it possible to link a cell background color to a dropdown list value? Or perhaps to make all cells containing certain values to become a certain color automatically?
Another question:
Is it possible to link a cell background color to a dropdown list value? Or perhaps to make all cells containing certain values to become a certain color automatically?
depends ,in excel version in 2007 you could use conditional formating as there is only a limit
based on availiable memory pre excel 2007 only 3 could be used to get arountd that try a bit of code
Please Login or Register to view this content.
go here
to get relevent colour index numbers
http://www.fontstuff.com/casebook/co...olorpicker.htm
Sorry about that, I'm using Excel 2007. Conditional formatting did the trick.
Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks