Forum Discussion
Solved
Conditional formatting on several colomns
Hello community!! I have a huge range of data. I need to put in red the MIN of each column. I can do this for one column. But how to do this for the whole range of data? (without doing it one col...
After you select the columns, just create a new rule with the formula.
If the columns start from B to H, then select only these columns and change the formula as follows:
=B1=MIN(B:B)
Assume you wanna apply New Rule from B2:H100.
1. Select from cell B2:H100.
2. In the CF, select use a formula to determine which cell to format
3. Type in the formula in the box below.
=MIN($B2:$100)=50
4. Click on the Format to setup your formatting such as Bold
5. Click OK
All the values that equal to 50 within the selected columns will have the rule applied
1. Select from cell B2:H100.
2. In the CF, select use a formula to determine which cell to format
3. Type in the formula in the box below.
=MIN($B2:$100)=50
4. Click on the Format to setup your formatting such as Bold
5. Click OK
All the values that equal to 50 within the selected columns will have the rule applied