I have 1490 hyperlinks in Excel that I need to identify as either being good or bad. These are all hyperlinks to PDF documents. An example of the file name is "C:\Users\Jennifer\Docs\Lease\12345-Lease.pdf". There are 1490 rows with this type of data in one column. Then in another column I have "=HYPERLINK(C4,"LEASE"). I would like to be able to highlight the bad hyperlinks in yellow. I assume a macro is the way to go but I can't figure it out....

Thanks!