Forum Discussion
Need to highlight group of rows by subtotal; Conditional Formatting Maybe?
I lost a format I used to have in a spreadsheet and can't find the way to re-create it again. It was a long time ago when originally created it. I need to highlight the group of rows which subtotal...
CDMWK40 Perhaps best demonstrated in a working example. See attached.
One more thing. If sum is less than say 250, then both group 1 and 2 will be highlighted or only group 2?
Please check the Manage rules logic built in enclosed sheet. Hope this helps.
ShishirKumar Well, it's not me who needs help. I had already offered, what I believe to be a working solution. It requires only one CF rule for the example in the file I uploaded. It's up to CDMWK40 to apply it to real data and come back if it doesn't work.
Don't understand why you provide a more complicated solution that achieves exactly the same as mine.