Hi bob,

actually, i need more then 4 but listed only 4 in my question...
Please help...
Pierre

Bob Phillips wrote:
Pierre,

You need more than 3, but only 4. You could set them all to a default
colour, say green for closed, and then use the 3 formats in CF to test for
other values.

Hi experts,

[quoted text clipped - 15 lines]
P.S. conditional formatting does not work beause i need more than three
colors...

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200512/1