Excel 2002 SP3

I would like to know how to achieve the following with a vba script or macro:

verify if the value of a hyperlink is the same a the value of the cell, e.g.
if the value of a cell is and the email hyperlink value is

then - ok (leave as it is)

but

if the value of a cell is and the email hyperlink value is

then - not ok (update email hyperlink with value of the cell)

and
when the cell is empty and hyperlink is filled in, cell should be updated.



Can this be scripted?
Thanks for any help as I don't seem to manage it right now.


Regards,
Bert