Conditional Formatting Question

[Roar]

I have read a few and seek to understand.

My sheet will have
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Training[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Onsite[/TD]
[TD]22,000[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Remote[/TD]
[TD]15,000[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]T&E Included[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I would like rows 2-4 to be shaded with dark gray if cell C1 = No so the person will know to ski the whole section.
If Yes, the fill can change back to nothing

 

[MarcelBeug]

Use Conditional Formatting with formula =$C$1="No", format fill with dark grey and apply to A2:C4.