LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default "background" formatting possible?

Hi, is it possible to format a background which will stay put while you
manipulate your data cells / insert rows on top? That would be SO useful.
E.g. I have a big table of data, and just for visual purposes, I want every
3rd line to be coloured, to make the table easier to read (esp when printed).
However, if I update the table and add a row in at the beginning / middle,
then it messes up the formatting pattern thereafter.
Any way of having your formatting independent of data on top?

Thanks
 
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
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
change background color of a cell with an "IF" command? Lee Excel Worksheet Functions 1 June 30th 07 07:41 PM
VBA code to "background-color" a cell obtaining a value from Row EagleOne Excel Discussion (Misc queries) 1 August 2nd 06 05:57 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 09:36 AM.

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

About Us

"It's about Microsoft Excel"