Forum Discussion
Jimmy0600
Jun 20, 2024Copper Contributor
How to conditionally format a range of not blank cells, then check & format per category
Is there a way to conditionally format a range of cells [$C$6:$AT$25 or named range] using formula for the following? - Firstly, check if cell is not blank [suggested code; NOT(ISBLANK($C$6:$AT$25))...
- Jun 21, 2024
Hi, Jimmy0600
you are welcome. This should work if i correctly understand what you are looking for. The example has 4 categories. For 23 categories (with 23 different colors) 23 conditional formatting rules are required.
OliverScheurich
Jun 21, 2024Gold Contributor
Hi, Jimmy0600
you are welcome. This should work if i correctly understand what you are looking for. The example has 4 categories. For 23 categories (with 23 different colors) 23 conditional formatting rules are required.
Jimmy0600
Jun 25, 2024Copper Contributor
Hi OliverScheurich,
That works perfectly, I've updated my spreadsheet with your formula and very happy with the result.
Thank you for your help, much appreciated.