Forum Discussion
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 column by one column of course)
thanks a lot for your help
best
hélène
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)
11 Replies
Hi,
Select all columns, then create a new custom rule with this formula:
=A1=MIN(A:A)
Hope that helps
hello Haytham Amairah
I know this looks trivial but could you describe step by step how you do this?
or with a small capture?
would be really nice
(do you use macro?)
🙂
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)
hello Haytham Amairah
thanks for your quick answer.
I'm trying this right now.
at first, it seems like random results but I should be doing this wrong.Trying again.
- 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
