Cells to change colour depending on specific text

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

Hi Fran Habbitts

Select A1:G1

Home tab > Conditional formatting > New Rule > Use a formula to determine which cells to format > Format values where this formula is true: =$S$1="Parts in" > format as required

Thank you benishiryo & Kevin - works perfectly. Just need to know how to mark it as solved!

I think it is at the top of the thread, Thread Tools!