Forum Discussion
Excel table styles
hi sorry so currently the sheet is arranged into single table with groups of subtasks that take up approximately 3-6 rows my hope was for a relatively easy way soapily different colours to these sections e.g the first section is alternate row colour dark blue light blue the next section dark grey light grey alternating through the sheet also there is approximately 1000 row so I didn't really fancy doing this manually
I can't put up a example till I'm back home tommorow
kind regards tim
There is "conditional formatting" capability, which might apply. The trick there is that there would need to be a "condition" defined. So a question: are the subtasks you mention identified with some field that makes any given grouping of cells uniquely identifiable? If so, you could use conditional formatting.
A lot depends here on how simple you're willing to be. If you just want to be clear on where each group of subtasks begins and ends, you could write a simple formula that assigns a letter code and just cycle through three or four codes. That way you could write conditional formatting rules such that all coded A could be with green background, B with yellow, C with pink....etc.
Is it safe to assume that once pointed in the right direction you'd like to figure out how to do it yourself? I'd be happy to work with your example file after you post it; but you've come this far on your own and might want to finish it off.
- That’s both some really good ideas I shall have a play about
Many thanks tim