Conditional Formatting Question

[Roar]

I have read a few and seek to understand.

My sheet will have

A	B	C
1	Training	No
2	Onsite	22,000
3	Remote	15,000
4	T&E Included	0

<tbody>
</tbody>

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.