Yes this can be done.
No need to copy the text to excel, you can just simply store the source code and then look through all the innertext tags looking for "local authorit".
Would be handy to see 2 or 3 of the links so that we can code it correctly first time without going back and forward.
You'll probably want something like this.
Sub LocalAuth()
Dim ieDoc As HTMLDocument
Dim IE As Object
Dim LastRow As Long
Dim x As Long
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For x = 1 To LastRow
IE.Navigate Range("A" & x).Value
Do While IE.ReadyState <> 4 Or IE.Busy = True
DoEvents
Loop
Set ieDoc = IE.document
Set tagName = IE.document.getElementsByTagName("p")
For Each Tag In tagName
If InStr(1, Tag.innerText, "local authorit", vbTextCompare) > 0 Then
Range("A" & x).Interior.Color = 65535
Exit For
End If
Next Tag
Next x
End Sub