Suppose I have this dataset (the variable is not important in this case)
I would like to add a color scale for % Missing
column, with light red being the lowest value and dark red being the highest value. However, I only want to do this if the cell value is greater or equal to 5. Is this possible? I can't find a way to do this through conditional formatting. TIA.