| View previous topic :: View next topic |
| Author |
Message |
Jezzta667
General User
Joined: 08 Feb 2012
Posts: 35
|
 Posted: Sun Apr 22, 2012 4:49 pm Post subject: Flagging Tabs |
 |
|
Hey guys,
One of my spreadsheets has all of my retail store's suppliers in separate tabs. Each sheet is dedicated to special orders for customers for that particular supplier. When an order has been sent, received and picked up, the entry is deleted.
Is there any way to "flag" the tabs to show which sheets currently have special orders in process? By this, I mean a little marker or something which will appear on the tab of each sheet that isn't empty in the relevant area.
Thanks. |
|
| Back to top |
|
 |
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 316
Location: victoria
|
| Posted: Sun Apr 22, 2012 9:14 pm Post subject: |
|
|
Not automatically that I know of but the tab can be colourised manually (by right clicking on the tabs) though this is only a recent addition I'm not sure that it works on versions previous to 3.3.
Perhaps a summary sheet might be worth considering, with a listing of all tabs and in column B a COUNTIF formula giving a count of outstanding orders.
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
|
