More then 3 Conditional formats, maybe if?

[djfatboyfats]

How do i get about 8 items to change colour depending on wording, i can only conditional format 3 items, is there another way we can do this maybe using if formulas?

Oh and depending on colour i may need to change the colour of the text

Can this be done?

Thanks

FBF

[shg]

You need VBA. See http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm

[martindwilson]

try this add in
http://www.xldynamic.com/source/xld.....Download.html

extends conditional formats from 3 to 30.