Conditional Formatting MAX excluding Subtotal
Closed
theresa
-
Dec 5, 2011 at 04:11 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 6, 2011 at 06:34 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 6, 2011 at 06:34 AM
Hello,
I am trying to apply conditional formatting to cells to see the max and min of the column. However within the column there are multiple subtotals that I want to exclude from this.
I tried just highlighting the cells that I need however it isn't working.
Help please!
I am trying to apply conditional formatting to cells to see the max and min of the column. However within the column there are multiple subtotals that I want to exclude from this.
I tried just highlighting the cells that I need however it isn't working.
Help please!
Related:
- Conditional Formatting MAX excluding Subtotal
- Free fire max download - Download - Battle royale
- Free fire max email id - Guide
- Max repel cheat code fire red - Guide
- Max active checking torrents - Guide
- Hbo max download pc - Download - Movies, series and TV
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 6, 2011 at 06:34 AM
Dec 6, 2011 at 06:34 AM
I am not too sure about it but I think you need to have a custom formula that can identify the cells that are your subtotal cells (or formula cells)