Description:
Conditional formatting is the great tool and "Color Scale" is the most convenient option of it. But regular tables typically begin with columns that contain non comparable data (such as "Sequence number" or "Name". So logically (and mostly for display purposes) the cells of this columns have to take the same colors as corresponding cells from the column where the "Color Scale" conditional formatting is used.

So it would be nice to apply the "Color Scale" conditional formatting bases on data from other column, or at least to have an ability to link cell’s format to cell with condition formatting.

Please find the attached screenshot for clarity.

Steps to Reproduce:
Format / Conditional / Color Scale

Actual Results:
We have only "Cell Range"

Expected Results:
"Formatting Cell Range"
"Conditional Cell Range"


Reproducible: Always


User Profile Reset: No



Additional Info:
-