Conditional Formatting for 6 inputs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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.CFPlus.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....
 
Thank you!

David McRitchie said:
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.CFPlus.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....
Click to expand...
 
Back
Top