ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using Format--Style only on certain cells (Excel 2003) (https://www.excelbanter.com/excel-discussion-misc-queries/170591-using-format-style-only-certain-cells-excel-2003-a.html)

It Is Me Here

Using Format--Style only on certain cells (Excel 2003)
 
I know you can use Format--Style to change the appearance of hyperlinks in
your document, for example, but how can you make hyperlinks appear red and
underlined in Column A, say, and green and underlined in Column B?

Thanks in advance!

Jim Cone

Using Format--Style only on certain cells (Excel 2003)
 

Iime,
Select the cells with the hyperlinks and change the font color.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"It Is Me Here"
wrote in message
I know you can use Format--Style to change the appearance of hyperlinks in
your document, for example, but how can you make hyperlinks appear red and
underlined in Column A, say, and green and underlined in Column B?

Thanks in advance!

Dave Peterson

Using Format--Style only on certain cells (Excel 2003)
 
Maybe you could create two different styles.

It Is Me Here wrote:

I know you can use Format--Style to change the appearance of hyperlinks in
your document, for example, but how can you make hyperlinks appear red and
underlined in Column A, say, and green and underlined in Column B?

Thanks in advance!


--

Dave Peterson


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com