Excel 2016 - mass change of hyperlink style 1

[pendle666]

Hello

I have a workbook containing around 15 sheets. Column A is a text field containing a name. Some of these names are a hyperlink to another file.

These were originally PHP files published on my webpage, but I want to have them as an Excel file. All the formatting is done, but the hyperlinks are in standard Microsoft blue and I want it is bold red.

I amended the existing hyperlink style to the format that I wanted, but it hasn't updated the existing style - they're still in blue.

I've only ever used hyperlinks in Word before and I'm happy in how to update styles, but I've no idea what to do in Excel.

Basically, where the cell is a hyperlink, I want it in bold, underlined and in red. There are thousands of cells, so a manual change I'd like to avoid if possible.

Many thanks

Pendle

thank you for helping

____________
Pendle

 

[SkipVought]

Hi,

Could you use AutoFilter to select all your links?

If so selected then a simple format BOLD & Font RED in one swell foop!

For instance:[tt] Contains //[/tt]

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[pendle666]

Oh of course! What an idiot - I just tried it and it works just fine.

thank you!

thank you for helping

____________
Pendle