Automatically highlighting Tabs using a conditional formula

Question

What conditional formula should I use to automatically highlight the Tabs based on a conditional cross reference if the values on the Summary page associated with the Tab names go below zero? 

For example, I have a Summary page with a list of the Tab names and the balances pulled over from each Tab.  When the corresponding balances go below zero, I'd like the associated Tab name to automatically get highlighted.

Answer 1

Finding the right instructions took a surprisingly lot of searching. All of the tips I initially found were manual, "... right click ...".

Eventually I found these macro tips:

https://www.extendoffice.com/documents/excel/40...

https://excelribbon.tips.net/T013138_Dynamicall...

https://www.thespreadsheetguru.com/blog/2014/9/...

https://stackoverflow.com/questions/12464457/ch...

Color related tips:

http://www.cpearson.com/excel/colors.aspx

Color Palette and the 56 Excel ColorIndex Colors

http://www.mvps.org/dmcritchie/excel/colors.htm

This is a VERY long article written for old versions of Excel. Has many macros

Attempts to equate Excel ColorIndex values to RGB colors used in HTML. Includes formatting colors: [BLACK] [BLUE] [CYAN] [GREEN] [MAGENTA] [RED] [WHITE] [YELLOW] [COLOR1]..[Color56] and other color information. Color Sorting (on another page). Also see of coloring based on cell type.

Scope of the Color Palette: Each workbook has it’s own palette. To change the default, change your book.xlt template http://dmcritchie.mvps.org/excel/template.htm for new workbooks.

Color Palette Generator,

http://www.degraeve.com/color-palette/index.php

degraeve, Enter the URL of an image to get a color palette (10 colors) that matches the image. Useful in creating a website color palette that matches a key image to be used for a website. [referened by Favicon Generator]

Answer 2

Hi,

Sorry for the inconvenience caused to you, Thank you so much for your valuable question please, If my understanding is right, I would suggest you to please see the below mentioned article once please (if not tried before) and see if it helps. I am hopeful that your query will be resolved, If the issue persists or if my understanding is different from your concern, kindly do let me know,waiting for your kind reply please.

https://www.ablebits.com/office-addins-blog/201...

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Please let me know, if that helps and feel free to ask back any question.

Kind Regards:

Yasir

Answer 3

Excel 2013 and Windows7

Answer 4

Are you referring to Microsoft Excel?

If yes, what version are you referring to and what version of Windows are you using?