LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default 2 questions on appearance

Q1

You could grey out all of the cells other that the information area. You
would need to manage the changing of that area, adding/removing information,
which can be done using conditional formatting (as long as the are in
question is not huge).

Q2

Excel 2003 has a facility to colour code the tabs, right-click on the tab
and select Tab Color ... from the menu.

--
__________________________________
HTH

Bob

"stew" wrote in message
...
Hi all

1st Question

Can I limit the visual area that can be viewed only to the area which has
information on a worksheet

2nd Question

can the tabs at the bottom showing the names of worksheets be colour coded
i.e. Data entry and read only different colours

Thank You for looking

Stew



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
View Questions and Answer to questions I created Roibn Taylor Excel Discussion (Misc queries) 4 July 24th 08 12:05 AM
appearance of a concatenated value Jan Buckley Excel Worksheet Functions 0 November 15th 06 09:29 PM
Cell appearance wisey_1 Excel Discussion (Misc queries) 3 July 19th 06 12:04 AM
Vlookup second appearance starguy Excel Discussion (Misc queries) 3 April 27th 06 12:49 PM
Cursor Appearance Mjohnson Excel Discussion (Misc queries) 1 November 9th 05 04:28 PM


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"