Is there a way to use one single color scale conditional formatting rule for the whole sheet, that will separately compare only the values from each independent individual row? It seems that this can be accomplished for columns but not rows.
Here is a super scaled down version of what I'm trying to accomplish but with a separate rule for each row... https://docs.google.com/spreadsheets/d/1FxM4YBoYIvsXVMJAQLmWldRG5CL0R-sxAQybOBCtVcY/edit?usp=sharing
Also, is there a way to have the color scale highlight for the lowest value color when there is only one value? Right now, if there's only one value it uses the highest value color. See my crude "scaler" fix in the sheet above.
Thank you for any help!