Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting for many criteria
Hi there
I have a schedule data base and want the font to change color if certain ports (over 10 ports) are on the schedule. They can all change to the same colour. When I go into the contional formatting, it allows only 3 conditions to be set. -- Thank-you! Ruth |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting for many criteria
You have at least 2 options:
1) Convert to Excel 2007. You can have more than 3 conditional formats 2) Set the "conditional" formats using VBA. See this article for more information http://www.mvps.org/dmcritchie/excel/event.htm#case -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Ruth" wrote: Hi there I have a schedule data base and want the font to change color if certain ports (over 10 ports) are on the schedule. They can all change to the same colour. When I go into the contional formatting, it allows only 3 conditions to be set. -- Thank-you! Ruth |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting for many criteria
Thank-you!
-- Thank-you! Ruth "Barb Reinhardt" wrote: You have at least 2 options: 1) Convert to Excel 2007. You can have more than 3 conditional formats 2) Set the "conditional" formats using VBA. See this article for more information http://www.mvps.org/dmcritchie/excel/event.htm#case -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Ruth" wrote: Hi there I have a schedule data base and want the font to change color if certain ports (over 10 ports) are on the schedule. They can all change to the same colour. When I go into the contional formatting, it allows only 3 conditions to be set. -- Thank-you! Ruth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting of 4 criteria | Excel Discussion (Misc queries) | |||
CONDITIONAL FORMATTING FOR MORE THAN 3 CRITERIA | Excel Discussion (Misc queries) | |||
need help with conditional formatting 3 criteria | Excel Worksheet Functions | |||
Conditional Formatting with more than 3 Criteria | Excel Discussion (Misc queries) | |||
Can I set more than three criteria for conditional formatting? | Excel Worksheet Functions |