There are actually 4 conditions if you count the default color.

You have 4 conditions in your example.

Format "New" cells with green/bold then use the 3 CF conditions for the other 3
words.

I'm not sure I would apply to the entire worksheet.

Would you ever use that many cells?

If you have more than 4 conditions you can use event code for multiple
conditions or use Bob Phillips' CFPlus add-in which allows for 30 CF

http://www.xldynamic.com/source/xld.....Download.html


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 17:52:00 -0800, AK9955
wrote:

Hi,
In my spreadsheet I would like to highlight 3+ text values in bold and
different colours. E.g. New = green/bold, Modify =blue/bold, Delete =
red/bold, Undecided = yellow/bold.

Conditional formatting only allows you to add 3 conditions. Can someone
provide some code so I can add more than 3 conditions. I would like to apply
the code to the whole spreadsheet (not just a range of cells). Thanks