|
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
|