How to make many Color Scales?

English
,
#1

I have some numeric data I would like to apply ‘color scale’ conditional formatting to.

Is there an easier way than manually making ~50 conditional formats, one for each column? There’s no ‘Column Cells’ instead of ‘All Cells.’

#2

Create the CF for the range in the first column and with Menu/Edit/Paste special [Shift+Ctrl+V] copy only format in the other columns.

#3

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.