Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MINIMUM
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MINIMUM
Selecting cell B2, format - conditional format.
change first box to: "formula is" =B2=MIN($B2,$D2,$F2) Set format to a yellow pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Pam M" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MINIMUM
1. Select columns B:F ..
2. From menu FormatConditional Formatting 3. For Condition1Select '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 ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "Pam M" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MINIMUM
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. Pam M wrote: 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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200908/1 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MINIMUM
I was so close==forgot the =B2 part! Works perfect--thanks so much
"Luke M" wrote: Selecting cell B2, format - conditional format. change first box to: "formula is" =B2=MIN($B2,$D2,$F2) Set format to a yellow pattern. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Pam M" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimum value look up | Excel Worksheet Functions | |||
Minimum IF | Excel Worksheet Functions | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
Minimum but One?? | Excel Worksheet Functions | |||
Minimum Value | Excel Worksheet Functions |