Forum Discussion
Conditional formatting on several colomns
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
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)
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.
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))
