Sam Hamels
New Member
- Joined
- Mar 20, 2018
- Messages
- 49
Let's say I have three columns:
A1:A10
B1:B10
C1:C10
Each column has its own data (for example, some numbers between 1 and 100)
I want to use conditional formatting with a two-color scale to visualize the lowest-to-highest values in each column
This can easily be achieved by setting up the same conditional formatting (with the same 'rule' and two-color scale) for each column separately
However, when you have a large amount of columns, this becomes cumbersome.
Especially if, for example, you want to change the colors used in the two-color scales.
I would prefer to have one rule that applies to every column separately, so I can change the applied rule or the colors once for all the separate columns.
I dont' want to simply select all columns at once (A1:C10) and then set up the conditional formatting, because the two-color scale would then be applied by looking at the values of that entire range, instead of considering the data in each column separately.
Cheers,
Sam
A1:A10
B1:B10
C1:C10
Each column has its own data (for example, some numbers between 1 and 100)
I want to use conditional formatting with a two-color scale to visualize the lowest-to-highest values in each column
This can easily be achieved by setting up the same conditional formatting (with the same 'rule' and two-color scale) for each column separately
However, when you have a large amount of columns, this becomes cumbersome.
Especially if, for example, you want to change the colors used in the two-color scales.
I would prefer to have one rule that applies to every column separately, so I can change the applied rule or the colors once for all the separate columns.
I dont' want to simply select all columns at once (A1:C10) and then set up the conditional formatting, because the two-color scale would then be applied by looking at the values of that entire range, instead of considering the data in each column separately.
Cheers,
Sam
Last edited: