Tab colour highlighting on selection

[#1]

Hi all

I'm trying to get the tabs to change background and text colour when selected.  I want white background and black text when inactive and blue background and white text when clicked on.

I've tried putting this formula in the tab settings:

If (GetActiveSheetId()='Document\SH01',RGB(0,128,255), White())

But I can't seem to get it to do it the right way round.  Can anyone help me with this?

TIA!

Regards

Alex

[#2]

Hello,

I've figured this out now, thanks for your time.

Regards

Alex

[ThornOfCrowns]

Would you like to report how you did it for the benefit of others who may read this thread in the future?

[dmohanty]

Hi,

Try using like this:

For Tab Color, Go to Sheet Properties>>Tab Settings>>Tab Color>>Custom Colors>>Calculated, put the expression:

if(GetActiveSheetId()='Document\SH01',blue(),white())

For TAb Text color, Go to Sheet Properties>>Tab Settings>>Tab Text Color>>Custom Colors>>Calculated, put the expression:

if(GetActiveSheetId()='Document\SH01',white(),black())

If this helps, mark the Post as Correct, to help others!

[#5]

Hi Alex,

Please find the attachment, May be it helps you.

[#6]

Sure thing!

For the tab colour, go to Sheet Properties click Custom Colour/Tab Colour.  First click Fixed and select the colour you want (mine was the following blue R=0, G=128, B=255).  Then select Calculated and enter the same colour into the Expression Box.  The formula is:

If(GetActiveSheetId()='Document\SH02',RGB(0,128,255),white())

Note: make sure that the sheet number (SH02) matches the Sheet ID or it won't appear to work.

For the text colour, click on Custom Colour/Tab Text Colour.  First click Fixed and select Black on the Basic Colours.  Then select Calculated and enter the following formula to get white: 

If(GetActiveSheetId()='Document\SH02',white(),black())

This will then give you the blue tab with white text when you select that tab.

Regards

Alex

[#7]

Thanks very much - I'm sure I'll use that somewhere on this app!

Regards

Alex