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,

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

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,

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