| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting group of cells | Excel Discussion (Misc queries) | |||
| How to apply conditional formatting on group of cells by using dat | Excel Discussion (Misc queries) | |||
| Group Repeating Text Values in a Column? | Excel Discussion (Misc queries) | |||
| Copying different repeating entries down a column | Excel Discussion (Misc queries) | |||
| conditional formating of group of columns and rows | Excel Worksheet Functions | |||
Threaded Mode
