Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
edited title
Link
Computer Candy
Computer Candy
  • 73
  • 2
  • 9

Google Sheets,: One Conditional Formatting Color Scale Rule - For, for multiple independent rows at once?

Source Link
Computer Candy
Computer Candy
  • 73
  • 2
  • 9

Google Sheets, Conditional Formatting Color Scale Rule - For multiple independent rows at once?

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!