You are here: HomeExcelTutorials

# Conditional Formatting: Highlight the lowest value

## Conditional Formatting: Highlight the lowest value

Price: FREE

I wanted to ask for your help as all my searches on conditional formatting don't seem to return quite what I am after.
On the attached spreadsheet I am trying to get the conditional formatting to highlight the lowest value, comparing very specific cells:
To highlight the lowest value of these cells: G6, N6, U6, AB6, AI6
While ignoring the other values in that row and ignoring blanks and any cells with 0 in.
I would be very grateful if someone could advise. The only things I can find are formulas that compare and highlight values in the entire row.

Visit publisher's web-site: Conditional Formatting: Highlight the lowest value

Category and Tags: ExcelTutorials :

## Related Tutorials

### Highlight lowest 10 entries out of latest 20 entries

Free: Yes
Tags: Excel ›

I was hoping somebody could help me out here:
I have three columns (Round, Date, Score) that I add entries to on a weekly (roughly) basis. The latest round score is always at the top.
Now I want to use conditional formatting to highlight the lowest 10 rounds, from the last 20 entries.
I know how to use conditional formatting to highlight the lowest 10 rounds, and I know how to highlight the last 20 rounds, however I don't know how to combine the two!

### Conditional Formatting using Small

Free: Yes
Tags: Excel ›

I have 9 columns and 52 rows that that have pricing for 9 brands for each week of the year. There may be some weeks where a brand as \$0.00 as a price. I am trying to do a conditional formatting to highlight the cell that has the lowest price for that week excluding any that have \$0.00 listed. I got a formula off the internet and adjusted to my spreadsheet. The formula listed below is in my conditional formatting rule
=C8=SMALL(C8:T8,1+COUNTIF(C8:T8,"0"))
It is not highlighting the \$0.00 cells, but some weeks it does not highlight anything. The odd part is that one week the lowest price is \$1.47 that does not highlight. If I change that to \$1.00 it does highlight, but if I change it to \$1.10 it does not.

### Conditional formatting highlight criteria

Free: Yes
Tags: Excel ›

How can I use conditional formatting to highlight 3 highest (or lowest) values within a range of values?

### Conditional formatting to highlight the lowest valid value

Free: Yes
Tags: Excel › Functions

Cell A1 contains a "critical value". I want to format the range B1:B5 so that one cell is highlighted - the cell with the value closest to, but not greater than, A1.
E.g. if B1:B5 looks like this:
ColB
9 <-- This should be highlighted when A1 = 14
16 <-- This should be highlighted when A1 = 16
58 <-- This should be highlighted when A1 = 30

### Highlight Column Conditional Formating

Free: Yes
Tags: Excel ›

I have a Excel 2003 workbook and have one single row which contains numbers. I am try to populate A1 with the lowest number in that row, which I can do by =MIN(B1:L1)
However I would like to highlight the 'whole' column (not single cell) that was identified as lowest. How do I identify the column Letter that is lowest and then highlight this with a color?

## Related Applications & Scripts

### BPower Unique Low Bid Auction

Free: No
Tags: PHP › Excel Auction Systems

ICLowBidAuction script is a Low Bid Auction software for setting up a comprehensive and robust lowest unique bid auction site with 2 types of low bid auctions: Classic and Lower. Site administrator can adjust auctions time, step and other parameters. Auction payments are via PayPal and other payment processors can be integrated.
Classic Unique Low Bid Auction
The auction works like a regular auction, the only difference is that the winner is the person who made the unique lowest bid.
The bids are made through the site and because they are secret, the point is to strategically identify the whole number that is the lowest among all the bids.
The auction will take place in a period of time defined by administrator and the winner is the one who has made the lowest unique bid among those involved.
Lower bid auction
Lower bid auction is a new type of online auctions for selling expensive goods and properties. It works like classic unique low bid auction with the one difference that auctions end when certain number of bids (can be defined by administrator) were made by buyers.

### jQuery FocusOn - Highlight an area of your website

Free: No
Tags: JavaScript › Excel jQuery

Tired of your clients missing some important feature of your web site?, maybe its new and you want to make them notice it.
jQuery FocusOn is a plugin that makes your clients fully focus on a certain area of your web site, it receives an element and will highlight the area of that element an make every thing else opaque and disabled for clicking.

### Animated tooltip with HTML formatting

Free: No
Tags: Flash › Excel ToolTips

A very nice and easy way of giving your visitors a quick explanation of a button. It has an alpha animation (which you can also turn off). You can also apply html formatting like bold text.

### Text Highlighter

Free: No
Tags: PHP › Excel WordPress Plugins

A plugin for highlighting your content text with background and font color. Giving your highlight text with clickable tags.
Key Features & Options
- Highlight all similiar text with comma separated.
- Support post type.
- Color picker with farbtastic.
- Support font and background color for for each post/page.
- Translation support.

### EditArea: source code editor

Free: Yes
Tags: JavaScript › Excel WYSIWYG Editors

Here is EditArea, a free javascript editor for source code. (That is no way a WYSIWYG editor). This editor is designed to edit souce code files in a textarea. The main goal is to allow text formatting, search and replace and real-time syntax highlight (for not too heavy text). This editor is free and freely distributable (released under LGPL, Apche and BSD licenses).
Customizable real-time syntax highlighting (currently: PHP, CSS, Javascript, Python, HTML, XML, VB, C, CPP, SQL, Pascal, Basic, Brainf*ck, and probably more...)