Simple Test To Return "YES" or "NO" if an adjacent cell contains a hyperlink to a link

Dear all is there a non-VBA way to test if a cell has a hyperlink property within it that points to a google drive file? If not can you please help with some VBA to be able to return a "YES" or "NO" if an adjacent contains a hyperlink

Many Thanks and happy new year to you all

Tanasedn

Thank you - reading over my question maybe I was not 100% clear in the way I asked the question. The hyperlink is not really in the cell as opposed to inserting a hyperlink as a property IE right-click > hyperlink
I have inserted a screenshot to show how I insert the hyperlink - thank you Attachment 812059

Ah yes I see what you mean - thank you for the heads up. I will do this

Many Thanks

-Peter

SO here attached is the example sheet
what I would like to do for the column E to show either YES or NO if the adjacent column D has a hyperlink within its properties IR right click > hyperlink ( and not simply within the cell )

Thank you

wow works great - thank you soooooooo much - 20 minutes on here is 100% better than hours and hours on google -

Thank you