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)
Can you paste the MIN formula you used for the sinlgle column
- 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