If cell contains "No", adjacent cells auto-populate "NA"

Hi all, I'm very new to VBA and would need your assistance on this which I've been trying to get it work but to no avail. I currently have a private sub for worksheet_change in my existing worksheet, and would now like to add a new criteria.

Currently, if "Any Funding?" column changes, both "Funding Approved?" and "Source of Funding" will be cleared of their contents. This is done with worksheet_change. Now, in the same "Any Funding" column, if selection is "No", I would like to set "Funding Approved?" and "Source of Funding" to "NA". Is this possible?


Current VBA is:

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("A2:A10")) Is Nothing Then
Target.Offset(0, 1).ClearContents
Target.Offset(0, 2).ClearContents
End If

End Sub

I've also attached a sample workbook for reference.
Thanks very much for anyone's help! Appreciate it!