My response was for one set of 3 numbers, not multiple sets (your question
did not indicate such). Unless you have xl2007, you aren't going to be able
do do much beyond 3 color formats anyway, without using VBA. And that's a
whole different ball of wax.

Perhaps if you explained what you were trying to accomplish... I.E: I want
to highlight cells that have the 3 digits of 245 green, 335 yellow, etc....,
but then to do what with them? What is your ultimate outcome. Are you
correcting them....or?
--
** John C **


"ghinzrey" wrote:

Wish Mr. Johnc could provide step by step as an example of what to do. Sorry,
but I'm just a beginner on excel. Thanks