![]() |
Change tab color based on current color of a cell
Greetings all!
I have a spreadsheet created in Excel 2007 that I am looking to have the tab of each sheet the same color as a specific cell within that sheet. The cell (M20) is a results cell that contains a formula and has conditional formatting which will shade the cell green if positive or red if negative. I would like each tab for each sheet to either be green or red depending on the color of cell M20. Is this possible? Thanks in advance. Mark |
All times are GMT +1. The time now is 09:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com