Hi There,

I would like cells A1:G1 to change colour when cell S1 reads "Parts In" which is one item on a drop down list please can you help - i assume this is conditional formatting but do not know how to write the formula.

Thanks in advance

Fran