Conditional formatting based on number of blank cells

[lizard_queen]

Hello,

I have figured out how to format my range (row) of columns into a single colour based on whether or not there is any blank cell in the specified range using the COUNTBLANK() function. However, I was wondering if it is possible to apply a gradient to this so that cells which have more blanks are coloured, say red, those with less being yellow and those that are complete being green (along a gradient)?

Thanks heaps

 

[Alex Blakenburg]

Applying a color gradient to the WHOLE row is the stumbling block.
The same issue is covered in this forum here conditionally-formatting-a-row-using-a-colour-scale
One suggested option is to apply colors to a number of different value ranges. This will not give a full spectrum but at least give color groupings.

For the formula to form a basis for the above substitute your conditional format formula with a Countifs.

=COUNTIFS($A10:$G$10,"")

And then pick colors base on that being > a nominated value, and repeat a number of timed in order.