Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I set more than three criteria for conditional formatting?
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. |
#2
|
|||
|
|||
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" wrote in message ... 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. |
#3
|
|||
|
|||
Take a look at http://xldynamic.com/source/xld.CFPlus.Download.html
-- HTH Bob Phillips "River" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
How do I enable the criteria pane in MSQuery (Excel 2003)? | Excel Discussion (Misc queries) | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |