|
How do i keep the colors applied to the specific rows when sor
Ok, I tried using cpearson's website and it was just way to complicated for
me to understand. I need every other row coloured tan and all the others white. I also need them to stay that way when I sort. I need this to start in row 3. What would be the formula or what else would I do? God Bless, Harley "Debra Dalgleish" wrote: You could use conditional formatting to colour the rows. Chip Pearson has instructions on his web site: http://www.cpearson.com/excel/banding.htm evas1ve wrote: I have applied specific colors to specifc rows, but when i sort the colored rows follow the sorting format. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
1. Because I don't know the name exactly of what I am needing done.. for
example banding or locking. 2. I tried the formula as he explained and it didn't work for me. 3. Maybe someone else could re-state it in a way that would more helpful. That is why someone here might be able to explain it better. There is more than way to explain something. Another thing, I hope you realize that the beginning of your response came of quite rude. "Tom Ogilvy" wrote: If you can't understand a well written explanation with pictures and so forth, why do you think a better answer can be given here? Why not go back and have another look. It isn't difficult and it would be important to understand how it works. If you need a sample workbook, contact me at with your email address. Be sure to include the text of your email. -- Regards, Tom Ogilvy "Crowraine" wrote in message ... Ok, I tried using cpearson's website and it was just way to complicated for me to understand. I need every other row coloured tan and all the others white. I also need them to stay that way when I sort. I need this to start in row 3. What would be the formula or what else would I do? God Bless, Harley "Debra Dalgleish" wrote: You could use conditional formatting to colour the rows. Chip Pearson has instructions on his web site: http://www.cpearson.com/excel/banding.htm evas1ve wrote: I have applied specific colors to specifc rows, but when i sort the colored rows follow the sorting format. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
You can use Conditional Formatting to color, say, odd numbered rows. But if
you sort the data, and what was row 3 now moves to row 4, it will no longer be colored. Is that what you want? If so, the formula to use with Conditional Formatting is =MOD(ROW(),2)=1 to color odd rows. Change the 1 to 0 to color even rows. On Sun, 30 Jan 2005 19:07:02 -0800, Crowraine wrote: 1. Because I don't know the name exactly of what I am needing done.. for example banding or locking. 2. I tried the formula as he explained and it didn't work for me. 3. Maybe someone else could re-state it in a way that would more helpful. That is why someone here might be able to explain it better. There is more than way to explain something. Another thing, I hope you realize that the beginning of your response came of quite rude. "Tom Ogilvy" wrote: If you can't understand a well written explanation with pictures and so forth, why do you think a better answer can be given here? Why not go back and have another look. It isn't difficult and it would be important to understand how it works. If you need a sample workbook, contact me at with your email address. Be sure to include the text of your email. -- Regards, Tom Ogilvy "Crowraine" wrote in message ... Ok, I tried using cpearson's website and it was just way to complicated for me to understand. I need every other row coloured tan and all the others white. I also need them to stay that way when I sort. I need this to start in row 3. What would be the formula or what else would I do? God Bless, Harley "Debra Dalgleish" wrote: You could use conditional formatting to colour the rows. Chip Pearson has instructions on his web site: http://www.cpearson.com/excel/banding.htm evas1ve wrote: I have applied specific colors to specifc rows, but when i sort the colored rows follow the sorting format. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
AAHH HAAA!! Conditional formatting. That is what I was missing!! I was typing
in the formula. Yep, that was what I meant, and your advice did the trick. Thank you. God Bless, Harley "Myrna Larson" wrote: You can use Conditional Formatting to color, say, odd numbered rows. But if you sort the data, and what was row 3 now moves to row 4, it will no longer be colored. Is that what you want? If so, the formula to use with Conditional Formatting is =MOD(ROW(),2)=1 to color odd rows. Change the 1 to 0 to color even rows. On Sun, 30 Jan 2005 19:07:02 -0800, Crowraine wrote: 1. Because I don't know the name exactly of what I am needing done.. for example banding or locking. 2. I tried the formula as he explained and it didn't work for me. 3. Maybe someone else could re-state it in a way that would more helpful. That is why someone here might be able to explain it better. There is more than way to explain something. Another thing, I hope you realize that the beginning of your response came of quite rude. "Tom Ogilvy" wrote: If you can't understand a well written explanation with pictures and so forth, why do you think a better answer can be given here? Why not go back and have another look. It isn't difficult and it would be important to understand how it works. If you need a sample workbook, contact me at with your email address. Be sure to include the text of your email. -- Regards, Tom Ogilvy "Crowraine" wrote in message ... Ok, I tried using cpearson's website and it was just way to complicated for me to understand. I need every other row coloured tan and all the others white. I also need them to stay that way when I sort. I need this to start in row 3. What would be the formula or what else would I do? God Bless, Harley "Debra Dalgleish" wrote: You could use conditional formatting to colour the rows. Chip Pearson has instructions on his web site: http://www.cpearson.com/excel/banding.htm evas1ve wrote: I have applied specific colors to specifc rows, but when i sort the colored rows follow the sorting format. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 02:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com