Can I set more than three criteria for conditional formatting?

The next step up after you can no longer use conditional formatting
is to use an Change Event macro
http://www.mvps.org/dmcritchie/excel/condfmt.htm#case

There is an addin that would work the same as conditional formatting
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"River" <River@discussions.microsoft.com> wrote in message news:4634DCCF-0DA1-4CA4-A625-B8CFDF90FE37@microsoft.com...
> I would like randomly repeated names in column C to set the colour of the
> font in column A (or for the colour of the font for the entire row).
> If I use conditional formatting I can only set three names from column C.
> However I have more names (8 - 10 ) in column C.
> Am using Office 2003.

Take a look at http://xldynamic.com/source/xld.CFPlus.Download.html

--
HTH

Bob Phillips

"River" <River@discussions.microsoft.com> wrote in message
news:4634DCCF-0DA1-4CA4-A625-B8CFDF90FE37@microsoft.com...
> I would like randomly repeated names in column C to set the colour of the
> font in column A (or for the colour of the font for the entire row).
> If I use conditional formatting I can only set three names from column C.
> However I have more names (8 - 10 ) in column C.
> Am using Office 2003.

The next step up after you can no longer use conditional formatting
is to use an Change Event macro
http://www.mvps.org/dmcritchie/excel/condfmt.htm#case

There is an addin that would work the same as conditional formatting
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"River" <River@discussions.microsoft.com> wrote in message news:4634DCCF-0DA1-4CA4-A625-B8CFDF90FE37@microsoft.com...
> I would like randomly repeated names in column C to set the colour of the
> font in column A (or for the colour of the font for the entire row).
> If I use conditional formatting I can only set three names from column C.
> However I have more names (8 - 10 ) in column C.
> Am using Office 2003.

Take a look at http://xldynamic.com/source/xld.CFPlus.Download.html

--
HTH

Bob Phillips

"River" <River@discussions.microsoft.com> wrote in message
news:4634DCCF-0DA1-4CA4-A625-B8CFDF90FE37@microsoft.com...
> I would like randomly repeated names in column C to set the colour of the
> font in column A (or for the colour of the font for the entire row).
> If I use conditional formatting I can only set three names from column C.
> However I have more names (8 - 10 ) in column C.
> Am using Office 2003.

I would like randomly repeated names in column C to set the colour of the
font in column A (or for the colour of the font for the entire row).
If I use conditional formatting I can only set three names from column C.
However I have more names (8 - 10 ) in column C.
Am using Office 2003.

The next step up after you can no longer use conditional formatting
is to use an Change Event macro
http://www.mvps.org/dmcritchie/excel/condfmt.htm#case

There is an addin that would work the same as conditional formatting
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"River" <River@discussions.microsoft.com> wrote in message news:4634DCCF-0DA1-4CA4-A625-B8CFDF90FE37@microsoft.com...
> I would like randomly repeated names in column C to set the colour of the
> font in column A (or for the colour of the font for the entire row).
> If I use conditional formatting I can only set three names from column C.
> However I have more names (8 - 10 ) in column C.
> Am using Office 2003.

Take a look at http://xldynamic.com/source/xld.CFPlus.Download.html

--
HTH

Bob Phillips

"River" <River@discussions.microsoft.com> wrote in message
news:4634DCCF-0DA1-4CA4-A625-B8CFDF90FE37@microsoft.com...
> I would like randomly repeated names in column C to set the colour of the
> font in column A (or for the colour of the font for the entire row).
> If I use conditional formatting I can only set three names from column C.
> However I have more names (8 - 10 ) in column C.
> Am using Office 2003.