I have 7 words in a Drop down list which can be chosen for each day of the
Year (a row for each day). I wish to have separate formatting for each of
these 7 words. Conditional formatting works great and is exactly what I
require, however I am limited only 3 different formats. Is there any way
around this?

Thanks