SOLVED

# Conditional formatting on several colomns

Occasional Contributor

# 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

11 Replies

# Re: Conditional formatting on several colomns

Can you paste the MIN formula you used for the sinlgle column

# Re: Conditional formatting on several colomns

hello @Abiola1

yes sure (note that this is for the MAX but I guess the logic behind is the same)

# Re: Conditional formatting on several colomns

@helene7

Hi,

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

`=A1=MIN(A:A)`

Hope that helps

# Re: Conditional formatting on several colomns

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

# Re: Conditional formatting on several colomns

hello @Haytham Amairah

I'm trying this right now.
at first, it seems like random results but I should be doing this wrong.

Trying again.

# Re: Conditional formatting on several colomns

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?)

# Re: Conditional formatting on several colomns

thank you for your help @Abiola1

unfortunately this is not what I am looking for .

Best

Hélène

best response confirmed by helene7 (Occasional Contributor)
Solution

# Re: Conditional formatting on several colomns

@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)`

# Re: Conditional formatting on several colomns

hello @Haytham Amairah

thanks a lot. I think it worked

best

Hélène

# Re: Conditional formatting on several columns

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.

# Re: Conditional formatting on several columns

Bob, that's separate question and better to start new conversation with it.

In brief, MIN() doesn't ignore dates which are internally integer numbers (e.g. 2 Nov 2020 = 44137), perhaps you other numbers are less than any date in the range.

Excel doesn't support union directly, as variant you may use =MIN(A1:A20,MIN(D1:D20))