Hi All,

Simple problem, I need to have more than 3 possible outcomes for a cell using conditional formatting. I have solved the problem by using CFPlus but that makes the spreadsheet take so long to load and I will be sending the spreadsheet out to other people. I would like to make the interface as quick as I possibly can.

Could someone please help me with the code for VBA to make it easier?

For example if a cell has the text Purple (Chaos) in it then I need the cell to turn purple. If it has the text Yellow (Fortune) then it needs to turn yellow.

Is this possible please?

Thanks

Danny