I have 3 main pages, Police Budget and PoliceBdgtDetail, and Data Sheet with more worksheets for each line item. For example: Other Prof Serv, Other Contractual Serv, Travel & Per Diem, etc. I want to add a hyperlink in both the main pages to each line item page. Those hyperlinks I have formatted as font Calibri 12 Black Bold, in cells that are formatted either gray or white color. I want to add hyperlinks in each line item worksheet to go to Police Budget, PoliceBdgtDetail, and my Data Sheet. The tabs of all my worksheets are in different colors and different font colors. If the color of the tab is light the font is black, if the color of the tab is dark the font is white.

So I would like to put in each of the line item worksheets 3 cells with the same cell color and font color & size that is on the Police Budget, PoliceBdgtDetail and Data Sheet worksheet tabs.

Because I formatted hyperlinks in the Police Budget worksheet to be font Calibri 12 Black Bold, in cells that are formatted either gray or white color, when I went to one of the line item worksheets to put in a hyperlink the formatted hyperlink was the same as in the Police Budget worksheet.

Is there any way to use conditional formatting or some other way to make hyperlinks formatted differently than what is in the Police Budget worksheet. I'm trying to color code as much as I can to make it easier to find, read and understand our budget and how we are doing staying under budget.

Thanks for any help.