I should have read the question properly before posting.

Have you looked at Conditional Formatting? Click in the first of your number
of trucks cells, Format | Conditional Formatting. Call Value Is - Equal To -
5. Then choose your formatting and OK your way out. Then click the Format
Painter button (the 'paintbrush') then drag all the way down the column.


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