Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Crowraine
 
Posts: n/a
Default make colour in rows stay

How can I lock the fill colours in a row even when I change around the data
or sort alphabetically?

Thanks and God Bless,
Harley
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Use CF
http://www.cpearson.com/excel/banding.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Crowraine" wrote in message ...
How can I lock the fill colours in a row even when I change around the data
or sort alphabetically?

Thanks and God Bless,
Harley



Reply
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
How do I make bi-Lingual on a colum in many rows? logengr Excel Discussion (Misc queries) 0 January 22nd 05 10:59 AM
make first few rows print on every page? CD New Users to Excel 3 January 3rd 05 06:07 AM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 10:56 PM
How do I make Excel automatically adjust a row's height once I in. sueuy Excel Worksheet Functions 1 December 2nd 04 05:35 PM
How can I make autofilter show the filtered number of rows bsell123 Excel Worksheet Functions 1 October 28th 04 06:12 PM


All times are GMT +1. The time now is 01:53 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"