M
MarkT
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 short 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? If not, can I have a check-box so that if selected the
tab for the sheet will turn a specific color?
Thanks in advance.
Mark
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 short 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? If not, can I have a check-box so that if selected the
tab for the sheet will turn a specific color?
Thanks in advance.
Mark