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,