I have a workbook that has dropdowns with Yes and No answers.

Is there a way to select a range of cells in another worksheet (some of
which may be merged) and Format those cells with a patter based on a Yes or
No answer in another worksheet?

I ran a macro to do it and got this but I don't know what to do with it or
how to correlate it with say, Requestor!B10 (example).

Sub ShadeCell()
Range("B15:V18").Select
With Selection.Interior
..ColorIndex = 2
..Pattern = xlGray25
..PatternColorIndex = xlAutomatic
End With
End Sub

Thank you in advance.
Rusty