Forum Discussion

Jimmy0600's avatar
Jimmy0600
Copper Contributor
Jun 20, 2024

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))...
  • OliverScheurich's avatar
    OliverScheurich
    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.

Resources