Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the smalle
If I have a colunm of numbers, can I conditionally format to highlite the
smallest value in the colunm? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the smalle
Try this:
Assume your numbers are in the range A1:A5 Select the range A1:A5 Goto FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN(A$1:A$5)) Click the Format button Select the style(s) desired OK out Biff "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the smalle
Yes, use a formula of
=A1=MIN(A:A) "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the sm
Bob:
Thanks for your reply. This didn't work for me. My Range is actually J6:J22 so I substituted: =J6=MIN(J6:J22) Does it make a difference if the values in the cells are dirived from a formular, <<< =IF(D6=0,0,((C6/(D6*2))+G6)) Darrell "Bob Phillips" wrote: Yes, use a formula of =A1=MIN(A:A) "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the sm
Biff:
Thanks for your reply. This didn't work for me. My Range is actually J6:J22 so I substituted: =AND(J6<"",J6=MIN(J$6:J$22)) Does it make a difference if the values in the cells are dirived from a formular, <<< =IF(D6=0,0,((C6/(D6*2))+G6)) Darrell "Biff" wrote: Try this: Assume your numbers are in the range A1:A5 Select the range A1:A5 Goto FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN(A$1:A$5)) Click the Format button Select the style(s) desired OK out Biff "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the sm
Hi
Did you do as Biff said and SELECT the range first? In your case select J6:J22, then apply the Conditional Formatting with Biff's formula. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Biff: Thanks for your reply. This didn't work for me. My Range is actually J6:J22 so I substituted: =AND(J6<"",J6=MIN(J$6:J$22)) Does it make a difference if the values in the cells are dirived from a formular, <<< =IF(D6=0,0,((C6/(D6*2))+G6)) Darrell "Biff" wrote: Try this: Assume your numbers are in the range A1:A5 Select the range A1:A5 Goto FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN(A$1:A$5)) Click the Format button Select the style(s) desired OK out Biff "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the sm
Roger:
Sometimes I need to be slapped across the head with a 2 x 4. Yes indeed, I needed to highlite the cells first. That did work. "Roger Govier" wrote: Hi Did you do as Biff said and SELECT the range first? In your case select J6:J22, then apply the Conditional Formatting with Biff's formula. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Biff: Thanks for your reply. This didn't work for me. My Range is actually J6:J22 so I substituted: =AND(J6<"",J6=MIN(J$6:J$22)) Does it make a difference if the values in the cells are dirived from a formular, <<< =IF(D6=0,0,((C6/(D6*2))+G6)) Darrell "Biff" wrote: Try this: Assume your numbers are in the range A1:A5 Select the range A1:A5 Goto FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN(A$1:A$5)) Click the Format button Select the style(s) desired OK out Biff "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the sm
Roger and Biff:
It appears that that isn't exactly what I wanted to do. Instead of the Range being J6:J22 I actually need to use a group of cells. J6 & J29 & J53 & J77 Should I use the same formula and just deliniate my cells with a method other than a colon? Darrell "Dr. Darrell" wrote: Roger: Sometimes I need to be slapped across the head with a 2 x 4. Yes indeed, I needed to highlite the cells first. That did work. "Roger Govier" wrote: Hi Did you do as Biff said and SELECT the range first? In your case select J6:J22, then apply the Conditional Formatting with Biff's formula. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Biff: Thanks for your reply. This didn't work for me. My Range is actually J6:J22 so I substituted: =AND(J6<"",J6=MIN(J$6:J$22)) Does it make a difference if the values in the cells are dirived from a formular, <<< =IF(D6=0,0,((C6/(D6*2))+G6)) Darrell "Biff" wrote: Try this: Assume your numbers are in the range A1:A5 Select the range A1:A5 Goto FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN(A$1:A$5)) Click the Format button Select the style(s) desired OK out Biff "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the sm
Yes
=AND(J6<"",J6=MIN($J$6,$J2$9,$J$53,$J$57)) -- Regards Roger Govier "Dr. Darrell" wrote in message ... Roger and Biff: It appears that that isn't exactly what I wanted to do. Instead of the Range being J6:J22 I actually need to use a group of cells. J6 & J29 & J53 & J77 Should I use the same formula and just deliniate my cells with a method other than a colon? Darrell "Dr. Darrell" wrote: Roger: Sometimes I need to be slapped across the head with a 2 x 4. Yes indeed, I needed to highlite the cells first. That did work. "Roger Govier" wrote: Hi Did you do as Biff said and SELECT the range first? In your case select J6:J22, then apply the Conditional Formatting with Biff's formula. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Biff: Thanks for your reply. This didn't work for me. My Range is actually J6:J22 so I substituted: =AND(J6<"",J6=MIN(J$6:J$22)) Does it make a difference if the values in the cells are dirived from a formular, <<< =IF(D6=0,0,((C6/(D6*2))+G6)) Darrell "Biff" wrote: Try this: Assume your numbers are in the range A1:A5 Select the range A1:A5 Goto FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN(A$1:A$5)) Click the Format button Select the style(s) desired OK out Biff "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the sm
Roger:
That was very helpful. If you don't mind, may I continue with a few more questions? Can I copy the Conditional Formating from the group of cells I just formated to other similar groups of cells i.e. (J7,J30,J54,J78) &(I6,I29,I53,I77)... This should probably be done as a Macro since I have to do this 20 or more times, but I'm not particularly adept at VBA. Darrell "Roger Govier" wrote: Yes =AND(J6<"",J6=MIN($J$6,$J2$9,$J$53,$J$57)) -- Regards Roger Govier "Dr. Darrell" wrote in message ... Roger and Biff: It appears that that isn't exactly what I wanted to do. Instead of the Range being J6:J22 I actually need to use a group of cells. J6 & J29 & J53 & J77 Should I use the same formula and just deliniate my cells with a method other than a colon? Darrell "Dr. Darrell" wrote: Roger: Sometimes I need to be slapped across the head with a 2 x 4. Yes indeed, I needed to highlite the cells first. That did work. "Roger Govier" wrote: Hi Did you do as Biff said and SELECT the range first? In your case select J6:J22, then apply the Conditional Formatting with Biff's formula. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Biff: Thanks for your reply. This didn't work for me. My Range is actually J6:J22 so I substituted: =AND(J6<"",J6=MIN(J$6:J$22)) Does it make a difference if the values in the cells are dirived from a formular, <<< =IF(D6=0,0,((C6/(D6*2))+G6)) Darrell "Biff" wrote: Try this: Assume your numbers are in the range A1:A5 Select the range A1:A5 Goto FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN(A$1:A$5)) Click the Format button Select the style(s) desired OK out Biff "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the sm
Hi
I made the references absolute in my posting (I also made a mistake with the last one, saying J57 instead of J77). as I had thought that it would just be those fixed 4 cells. If you remove the $ signs to make the formula relative, then it can be copied to other cells as you describe. =AND(J6<"",J6=MIN(J6,J29,J53,J77)) The easiest way, is to use the Format painter. Place your cursor in cell J6, click on the Format Painter ( paintbrush icon on Toolbar) and "paint" the format to any other cells you want. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Roger: That was very helpful. If you don't mind, may I continue with a few more questions? Can I copy the Conditional Formating from the group of cells I just formated to other similar groups of cells i.e. (J7,J30,J54,J78) &(I6,I29,I53,I77)... This should probably be done as a Macro since I have to do this 20 or more times, but I'm not particularly adept at VBA. Darrell "Roger Govier" wrote: Yes =AND(J6<"",J6=MIN($J$6,$J2$9,$J$53,$J$57)) -- Regards Roger Govier "Dr. Darrell" wrote in message ... Roger and Biff: It appears that that isn't exactly what I wanted to do. Instead of the Range being J6:J22 I actually need to use a group of cells. J6 & J29 & J53 & J77 Should I use the same formula and just deliniate my cells with a method other than a colon? Darrell "Dr. Darrell" wrote: Roger: Sometimes I need to be slapped across the head with a 2 x 4. Yes indeed, I needed to highlite the cells first. That did work. "Roger Govier" wrote: Hi Did you do as Biff said and SELECT the range first? In your case select J6:J22, then apply the Conditional Formatting with Biff's formula. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Biff: Thanks for your reply. This didn't work for me. My Range is actually J6:J22 so I substituted: =AND(J6<"",J6=MIN(J$6:J$22)) Does it make a difference if the values in the cells are dirived from a formular, <<< =IF(D6=0,0,((C6/(D6*2))+G6)) Darrell "Biff" wrote: Try this: Assume your numbers are in the range A1:A5 Select the range A1:A5 Goto FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN(A$1:A$5)) Click the Format button Select the style(s) desired OK out Biff "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the sm
Roger:
Once again, Thank you. I have duplicated the Conditional Formating using the MAX Function, It works good as well. I have room for 1 more Conditional Format. Can I easily identify the next to the lowest value in these cells? Darrell "Roger Govier" wrote: Hi I made the references absolute in my posting (I also made a mistake with the last one, saying J57 instead of J77). as I had thought that it would just be those fixed 4 cells. If you remove the $ signs to make the formula relative, then it can be copied to other cells as you describe. =AND(J6<"",J6=MIN(J6,J29,J53,J77)) The easiest way, is to use the Format painter. Place your cursor in cell J6, click on the Format Painter ( paintbrush icon on Toolbar) and "paint" the format to any other cells you want. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Roger: That was very helpful. If you don't mind, may I continue with a few more questions? Can I copy the Conditional Formating from the group of cells I just formated to other similar groups of cells i.e. (J7,J30,J54,J78) &(I6,I29,I53,I77)... This should probably be done as a Macro since I have to do this 20 or more times, but I'm not particularly adept at VBA. Darrell "Roger Govier" wrote: Yes =AND(J6<"",J6=MIN($J$6,$J2$9,$J$53,$J$57)) -- Regards Roger Govier "Dr. Darrell" wrote in message ... Roger and Biff: It appears that that isn't exactly what I wanted to do. Instead of the Range being J6:J22 I actually need to use a group of cells. J6 & J29 & J53 & J77 Should I use the same formula and just deliniate my cells with a method other than a colon? Darrell "Dr. Darrell" wrote: Roger: Sometimes I need to be slapped across the head with a 2 x 4. Yes indeed, I needed to highlite the cells first. That did work. "Roger Govier" wrote: Hi Did you do as Biff said and SELECT the range first? In your case select J6:J22, then apply the Conditional Formatting with Biff's formula. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Biff: Thanks for your reply. This didn't work for me. My Range is actually J6:J22 so I substituted: =AND(J6<"",J6=MIN(J$6:J$22)) Does it make a difference if the values in the cells are dirived from a formular, <<< =IF(D6=0,0,((C6/(D6*2))+G6)) Darrell "Biff" wrote: Try this: Assume your numbers are in the range A1:A5 Select the range A1:A5 Goto FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN(A$1:A$5)) Click the Format button Select the style(s) desired OK out Biff "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
If I have a colunm of numbers, can I format to highlite the sm
Take a look at the Small and Large functions
=SMALL((J6,J29,J53,J77),2) would return the second smallest of values in J6, J29, J53 and J77 =Large(A1:A20,3) would return the 3rd largest of the range A1 to A20 -- Regards Roger Govier "Dr. Darrell" wrote in message ... Roger: Once again, Thank you. I have duplicated the Conditional Formating using the MAX Function, It works good as well. I have room for 1 more Conditional Format. Can I easily identify the next to the lowest value in these cells? Darrell "Roger Govier" wrote: Hi I made the references absolute in my posting (I also made a mistake with the last one, saying J57 instead of J77). as I had thought that it would just be those fixed 4 cells. If you remove the $ signs to make the formula relative, then it can be copied to other cells as you describe. =AND(J6<"",J6=MIN(J6,J29,J53,J77)) The easiest way, is to use the Format painter. Place your cursor in cell J6, click on the Format Painter ( paintbrush icon on Toolbar) and "paint" the format to any other cells you want. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Roger: That was very helpful. If you don't mind, may I continue with a few more questions? Can I copy the Conditional Formating from the group of cells I just formated to other similar groups of cells i.e. (J7,J30,J54,J78) &(I6,I29,I53,I77)... This should probably be done as a Macro since I have to do this 20 or more times, but I'm not particularly adept at VBA. Darrell "Roger Govier" wrote: Yes =AND(J6<"",J6=MIN($J$6,$J2$9,$J$53,$J$57)) -- Regards Roger Govier "Dr. Darrell" wrote in message ... Roger and Biff: It appears that that isn't exactly what I wanted to do. Instead of the Range being J6:J22 I actually need to use a group of cells. J6 & J29 & J53 & J77 Should I use the same formula and just deliniate my cells with a method other than a colon? Darrell "Dr. Darrell" wrote: Roger: Sometimes I need to be slapped across the head with a 2 x 4. Yes indeed, I needed to highlite the cells first. That did work. "Roger Govier" wrote: Hi Did you do as Biff said and SELECT the range first? In your case select J6:J22, then apply the Conditional Formatting with Biff's formula. -- Regards Roger Govier "Dr. Darrell" wrote in message ... Biff: Thanks for your reply. This didn't work for me. My Range is actually J6:J22 so I substituted: =AND(J6<"",J6=MIN(J$6:J$22)) Does it make a difference if the values in the cells are dirived from a formular, <<< =IF(D6=0,0,((C6/(D6*2))+G6)) Darrell "Biff" wrote: Try this: Assume your numbers are in the range A1:A5 Select the range A1:A5 Goto FormatConditional Formatting Formula Is: =AND(A1<"",A1=MIN(A$1:A$5)) Click the Format button Select the style(s) desired OK out Biff "Dr. Darrell" wrote in message ... If I have a colunm of numbers, can I conditionally format to highlite the smallest value in the colunm? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell format: numbers won't be numbers | Excel Discussion (Misc queries) | |||
Conditional format from a list of numbers | Excel Discussion (Misc queries) | |||
Format numbers in chart datatable | Charts and Charting in Excel | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
Mail Merge - format of numbers | Excel Discussion (Misc queries) |