Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for 6 inputs
Good Morning -
I am working off Excel 2003 and need to do conditional formatting for 6 inputs. On-Track is green Concerns is yellow At Risk is red Decision Required is light blue Decision Required (Customer) is gray Completed is light green I there a way to make this happen? All help is appreciated. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for 6 inputs
Hi Sher,
Can be done with Excel 2007; meanwhile, your best bet is probably Extended Conditional Formatter «Excel addin«, Bob Phillips & Frank Kabel, Addin that makes it possible to enter up to 50 conditions with the same entry type panels as builtin Conditional Formatting. http://www.xldynamic.com/source/xld.....Download.html another choice would be to write your own Event macro http://www.mvps.org/dmcritchie/excel/event.htm -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Sher" wrote.... I am working off Excel 2003 and need to do conditional formatting for 6 inputs. (conditions) On-Track is green Concerns is yellow At Risk is red Decision Required is light blue Decision Required (Customer) is gray Completed is light green |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for 6 inputs
CF in 2003 is limited to 3 formats (+ a fourth one for the base condition if
none of the 3 specified conditions are met), so for 6 you'd need VBA, along the lines of http://www.mvps.org/dmcritchie/excel/event.htm#case More CF advice at http://www.mvps.org/dmcritchie/excel/condfmt.htm -- David Biddulph "Sher" wrote in message ... Good Morning - I am working off Excel 2003 and need to do conditional formatting for 6 inputs. On-Track is green Concerns is yellow At Risk is red Decision Required is light blue Decision Required (Customer) is gray Completed is light green I there a way to make this happen? All help is appreciated. Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for 6 inputs
Thank you!
"David McRitchie" wrote: Hi Sher, Can be done with Excel 2007; meanwhile, your best bet is probably Extended Conditional Formatter «Excel addin«, Bob Phillips & Frank Kabel, Addin that makes it possible to enter up to 50 conditions with the same entry type panels as builtin Conditional Formatting. http://www.xldynamic.com/source/xld.....Download.html another choice would be to write your own Event macro http://www.mvps.org/dmcritchie/excel/event.htm -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Sher" wrote.... I am working off Excel 2003 and need to do conditional formatting for 6 inputs. (conditions) On-Track is green Concerns is yellow At Risk is red Decision Required is light blue Decision Required (Customer) is gray Completed is light green |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Automatic Histogram with Inputs | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Copying field inputs | Excel Discussion (Misc queries) |