Forum Discussion

Copper Contributor

Feb 09, 2020

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...

Haytham Amairah
Feb 09, 2020
helene7

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)

Haytham Amairah

Silver Contributor

Feb 09, 2020

Hi,

Select all columns, then create a new custom rule with this formula:

=A1=MIN(A:A)

Hope that helps

Highlight the minimum value for all column using one rule.xlsm17 KB

helene7
Copper Contributor
Feb 09, 2020
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?)
🙂
- Haytham Amairah
  Silver Contributor
  Feb 09, 2020
  helene7
  
  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)
  - Bob_Beattie
    Copper Contributor
    Nov 02, 2020
    Haytham Amairah
    
    Hi,
    
    I have several columns of data separated by columns of text and dates. I need to use the MIN function to process the data while ignoring the text and dates. =min(A1:A20) works as expected, but I cannot link multiple columns into the calculation. I would expect that something like =min((A1:A20),(D1:D20))
    would work. Where do I go from here?
    
    Thanks,
    
    Bob.
helene7
Copper Contributor
Feb 09, 2020
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.