Home 
Search 
Today's Posts 
#1




Highlight highest / lowest number in a row
Hi,
How do you highlight the highest / lowest number in a row? Example  Jan  77.9, 83.5, 88.9, 67.1 Feb  91.1, 85.9, 73.8, 83.2 How do you make it to highlight 88.9 since it is the highest among row for Jan 91.1 for Feb? I may need to highlight for the lowest number as well in other sheets. Thank you!!!! 
#2




Highlight highest / lowest number in a row
You can do this with conditional formatting.
Suppose that your series is in row 2. Select cell B2. Format  Conditional Formatting... Condition 1  Select Formula Is  enter formula =B2=MAX(2:2)  click on Format and select a pattern Click on Add Condition 2  Select Formula Is  enter formula =B2=MIN(2:2)  click on Format and select a pattern Click OK Select the cell you have just formatted, click the Format Painter button, apply to whole row. Ed Ferrero http://www.edferrero.com Hi, How do you highlight the highest / lowest number in a row? Example  Jan  77.9, 83.5, 88.9, 67.1 Feb  91.1, 85.9, 73.8, 83.2 How do you make it to highlight 88.9 since it is the highest among row for Jan 91.1 for Feb? I may need to highlight for the lowest number as well in other sheets. Thank you!!!! 
#3




Highlight highest / lowest number in a row
Thanks! I did a test, it works but there is some issue that happened.
Column A is for the month. Say, the month is Jan in cell A1, Feb in cell A2 For some reasons, when I format the date in column A to make them to display as Jan 07, Feb 07, Mar 07.. so on. The condition for highlighting the maximum of the cells got removed. Leaving the minimum condition that could work. What can I do to fix that? Thank you!! Thanks! On Mar 28, 6:41 pm, "Ed Ferrero" wrote: You can do this with conditional formatting. Suppose that your series is in row 2. Select cell B2. Format  Conditional Formatting... Condition 1  Select Formula Is  enter formula =B2=MAX(2:2)  click on Format and select a pattern Click on Add Condition 2  Select Formula Is  enter formula =B2=MIN(2:2)  click on Format and select a pattern Click OK Select the cell you have just formatted, click the Format Painter button, apply to whole row. Ed Ferrerohttp://www.edferrero.com Hi, How do you highlight the highest / lowest number in a row? Example  Jan  77.9, 83.5, 88.9, 67.1 Feb  91.1, 85.9, 73.8, 83.2 How do you make it to highlight 88.9 since it is the highest among row for Jan 91.1 for Feb? I may need to highlight for the lowest number as well in other sheets. Thank you!!!! Hide quoted text   Show quoted text  
#4




Highlight highest / lowest number in a row
Excel dates are stored as numbers, for instance 112007 is 39083, and will
display as a date if the cell is formatted with a date format. So applying the conditional format with the formula =B2=MAX(2:2) will identify cell B1 (containing the date) as the largest number in row 2. To get around this, either change the dates in column A to text, or change the conditional formula to =B2=LARGE(2:2,2). This finds the second largest number in row 2. Be careful, if you have large numbers in the row, this formula will highlight the date in column A instead of the largest number in your data. Ed Ferrero Thanks! I did a test, it works but there is some issue that happened. Column A is for the month. Say, the month is Jan in cell A1, Feb in cell A2 For some reasons, when I format the date in column A to make them to display as Jan 07, Feb 07, Mar 07.. so on. The condition for highlighting the maximum of the cells got removed. Leaving the minimum condition that could work. What can I do to fix that? Thank you!! Thanks! On Mar 28, 6:41 pm, "Ed Ferrero" wrote: You can do this with conditional formatting. Suppose that your series is in row 2. Select cell B2. Format  Conditional Formatting... Condition 1  Select Formula Is  enter formula =B2=MAX(2:2)  click on Format and select a pattern Click on Add Condition 2  Select Formula Is  enter formula =B2=MIN(2:2)  click on Format and select a pattern Click OK Select the cell you have just formatted, click the Format Painter button, apply to whole row. Ed Ferrerohttp://www.edferrero.com Hi, How do you highlight the highest / lowest number in a row? Example  Jan  77.9, 83.5, 88.9, 67.1 Feb  91.1, 85.9, 73.8, 83.2 How do you make it to highlight 88.9 since it is the highest among row for Jan 91.1 for Feb? I may need to highlight for the lowest number as well in other sheets. Thank you!!!! Hide quoted text   Show quoted text  
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
highlight highest and lowest cells within a given column in ex  New Users to Excel  
highlight highest and lowest cells within a given column in excel  New Users to Excel  
highlight highest and lowest cells within a given column in excel  New Users to Excel  
Sort from lowest to highest  Excel Worksheet Functions  
Highlight lowest number  Excel Discussion (Misc queries) 