colour a row depending upon a value or values in a specfic column

[kevindem]

I want to color fill or change a font color in a row from A to G based upon specifc numbers entered into column A1 to A100 see attached sample sheet
such that if A1:A100 contains 33079 i want to fill the cells A to H with a specfic color and do this for all occurances of that number and then do the same again for up to 5 different number values in column A this in in Excel 2003 thanks for any suggestions.

[Leith Ross]

Hello kevindem,

Welcome to the Forum!

You need to list the numbers you are looking for and what color or color index number is to be assigned to that number. You changed the font already in cells I1,J1,I3, and J3. These cells aren't part of the range A:H. Are these to be ignored?

[kevindem]

ok here are the numbers.. 33014 33055 33054 33057 33060 as for the colors im not real picky i just wanted them to contrast each other so it was easier to see the different parts and Im only worried about the color/font or fill in column A thru I