Conditionally format all cells based on their value

[DashboardNovice]

I using the CF option 'Format all cells based on their values' with a 3 color scale. The highest value is formula driven which evaluates to 5.

All possible values are 1 - 5, and blank cells.

For the minimum value I want a blank cell. So the lowest value will be blank cell, then 1, 2, 3, 4 and 5. Is it possible to specify a minimum value as a blank?

I tried the ISBLANK formula. I also tried referencing a blank cell and testing if it is blank, but nothing is working.

Really the values are 0 - 5, but I don't want to display zeroes unnecessarily, so in cases where I do have a 0, I have a formula to set that cell to a blank. That is why I need to apply CF to blanks, instead of zeroes.

 

[Hui]

You can also use a Custom Number Format to Display 0's as blanks
simply leave the third entry of the Number Format as "" eg: 0.0;-0.0;"";

 

[DashboardNovice]

Cool.

You can also use a Custom Number Format to Display 0's as blanks
simply leave the third entry of the Number Format as "" eg: 0.0;-0.0;"";

I will look into this. Thank you.