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)
Hi,
Select all columns, then create a new custom rule with this formula:
=A1=MIN(A:A)
Hope that helps
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.