| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
changing tab color conditionally
I have a Workbook that contains several pages. Each page represents a different style of product. When my customer sends in an order I place the order quantity in a certain named cell on the corresponding worksheet. Is there a way that I can format the tab to change color if the quantity of the named cell is greater than 0? Thanks in advance. -- ldd ------------------------------------------------------------------------ ldd's Profile: http://www.excelforum.com/member.php...o&userid=19157 View this thread: http://www.excelforum.com/showthread...hreadid=378510 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic changing refrences to sheet corresponding to first day. | Excel Discussion (Misc queries) | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
| How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
| changing page break in an excel file | New Users to Excel | |||
| Quickly Changing Several Series to Appear the Same | Charts and Charting in Excel | |||
Threaded Mode
