MINIMUM

P

Pam M

How can I conditional format for minimum if the cells are non adjacent?


A hidden B C hidden D E hidden F
keyed# formula entered# formula entered# formula

I then want to find the minimum of B, D, and F and highlight it yellow.
 
L

Luke M

Selecting cell B2, format - conditional format.
change first box to: "formula is"
=B2=MIN($B2,$D2,$F2)

Set format to a yellow pattern.
 
J

Jacob Skaria

1. Select columns B:F ..
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=AND(B1<>"",B1=MIN($B1,$D1,$F1))

1 in the formula is the 1st row in the selection. Adjust to suit

4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK



If this post helps click Yes
 
P

pogiman via OfficeKB.com

Try this:

Using conditional formatting on Columns B, D and F, enter Cell Value is equal
to =MIN($B#,$D#,$F#)

Just replace the # with the row# then copy it down.

Hope this works.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top