Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 7th 08, 11:14 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 133
Default conditional formatting to group rows with repeating entries

I've got a big list of records which I would like to group into visible
sections by colour according to a field, i.e. all rows with the same value in
that field show in yellow, the next "group" showing without a background
colour, then the next group in yellow again and so on- basically, a variation
on the alternating coloured rows you can do with a MOD(ROW) formula.

Does anyone know a conditional formatting formula solution to this?

  #2   Report Post  
Old July 7th 08, 11:47 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 2,420
Default conditional formatting to group rows with repeating entries

Just test that cell for a value,
http://www.contextures.com/xlCondFormat01.html

--
__________________________________
HTH

Bob

"Smallweed" wrote in message
...
I've got a big list of records which I would like to group into visible
sections by colour according to a field, i.e. all rows with the same value
in
that field show in yellow, the next "group" showing without a background
colour, then the next group in yellow again and so on- basically, a
variation
on the alternating coloured rows you can do with a MOD(ROW) formula.

Does anyone know a conditional formatting formula solution to this?



  #3   Report Post  
Old July 7th 08, 01:21 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 133
Default conditional formatting to group rows with repeating entries

Thanks Bob but there are too many values for that cell to individually
enumerate them in a Cell Value Is statement. What I need is a Formula that
looks at the relevant cells and returns the rows with the same value. I
tried =$B1=$B2 (the cells that match are in the B column) but this misses the
final row of each group.
However, perhaps I'm being too ambitious with conditional formatting....

"Bob Phillips" wrote:

Just test that cell for a value,
http://www.contextures.com/xlCondFormat01.html

--
__________________________________
HTH

Bob

"Smallweed" wrote in message
...
I've got a big list of records which I would like to group into visible
sections by colour according to a field, i.e. all rows with the same value
in
that field show in yellow, the next "group" showing without a background
colour, then the next group in yellow again and so on- basically, a
variation
on the alternating coloured rows you can do with a MOD(ROW) formula.

Does anyone know a conditional formatting formula solution to this?




  #4   Report Post  
Old July 7th 08, 02:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 2,420
Default conditional formatting to group rows with repeating entries

I am not sure I get it, but can't you use

=ISNUMBER(MATCH($B2,{1,2,3,4,5,99,73},0))

changing that array of values to suit

--
__________________________________
HTH

Bob

"Smallweed" wrote in message
...
Thanks Bob but there are too many values for that cell to individually
enumerate them in a Cell Value Is statement. What I need is a Formula
that
looks at the relevant cells and returns the rows with the same value. I
tried =$B1=$B2 (the cells that match are in the B column) but this misses
the
final row of each group.
However, perhaps I'm being too ambitious with conditional formatting....

"Bob Phillips" wrote:

Just test that cell for a value,
http://www.contextures.com/xlCondFormat01.html

--
__________________________________
HTH

Bob

"Smallweed" wrote in message
...
I've got a big list of records which I would like to group into visible
sections by colour according to a field, i.e. all rows with the same
value
in
that field show in yellow, the next "group" showing without a
background
colour, then the next group in yellow again and so on- basically, a
variation
on the alternating coloured rows you can do with a MOD(ROW) formula.

Does anyone know a conditional formatting formula solution to this?








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
conditional formatting group of cells dantee Excel Discussion (Misc queries) 2 June 13th 07 08:12 AM
How to apply conditional formatting on group of cells by using dat Jon Excel Discussion (Misc queries) 7 April 9th 07 11:40 AM
Group Repeating Text Values in a Column? ConfusedNHouston Excel Discussion (Misc queries) 1 April 25th 06 03:59 PM
Copying different repeating entries down a column Access Joe Excel Discussion (Misc queries) 2 January 13th 06 03:34 PM
conditional formating of group of columns and rows Madhav Excel Worksheet Functions 0 March 8th 05 07:21 PM


All times are GMT +1. The time now is 10:49 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017