Conditional formatting question on multiple rows

[PCRIDE]

How do I use the conditional formatting option for "Use Formula" option on a per row basis?

In my example I have a status field as Closed, once the status is set to Closed it will Strike Through all the text in the next 5 columns in that row. How do I drag this Conditional Formatting formatting for all of the rows to work independently of its status field?

Right now it seems you have to do one Conditional format rule per row?

 

[PCRIDE]

It is what the rule does.
But it should be like this:
=$C2="Closed"
Applies to:
=$D$2:$H$38


I attached my test file for you to review.

https://www.dropbox.com/s/jjhkic3ugl8gfgl/cf closed.xlsx?dl=0

Perfect that worked! I guess it was the $C2 reference vs using the default which it puts $C$2 or just removing the dollar signs all together.

Thanks for your help on this Dante!

 

[DanteAmor]

Perfect that worked! I guess it was the $C2 reference vs using the default which it puts $C$2 or just removing the dollar signs all together.

Thanks for your help on this Dante!

I'm glad to know that it works for you, it's the same formula that I put from post #5 .
Thanks for the feedback.