conditional formatting

[dalekirk01]

I want to use conditional formatting to format columns A-C, based on the value in column S and I want to do this on every row.

For example:
A4 - C4, formatted yellow based on value of S4
A5 - C5, formatted yellow based on value of S5
A6 - C6, formatted yellow based on value of S6

I can do this for one row using the conditional formatting option 'Format Values where formula is true' =$S$4="Yes"

But how do I then copy that formatting rule to every row?

 

[etaf]

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A4:C1000 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=$S4="whatever the value is you want to change to yellow"

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

Now it will format all the rows from 4 to 1000 Yellow if S is = to what ever value you need