Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I have a range of data and I would like to highlight the minimum value in

this range (minimum value different from zero).

Ex:

12, 0, 5, 1, 0, 10 : the minimum in this range, different from zero is 1.

Is this possible by Conditional Formatting or should I use VBA?

You dont need VBA for this. Your range is in B1:B6. Conditional

formatting of cell B1: choose

'Formula is:' and enter this:

=B1=SMALL($B$1:$B$6,COUNTIF($B$1:$B$6,"<=0")+1)

and set how you want it to be highlighted. Then using the Format

Painter icon on the Standard Toolbar, copy to B2:B6.

This excludes negative numbers as well as zeroes.

Didn't find what you were looking for?
Find more on Highlight a Cell, VBA or CF?
Or get search suggestion and latest updates.

Related Topics:

- Copying current cell's value to another cell
- Select random cell in list and highlight contents
- Using excel VBA to change a cell color
- VBA code to add values in two cells which have formulas
- Excel VBA Check When Cell Has Changed
- VBA Array - return value to a cell
- making a spreadsheet cell name a global variable in the VBA project
- Editing cell references w/ VBA
- VBA TO SELECT ALL EMPTY CELL IN SUDOKU3*3
- FormulaHidden property for a merged cell in VBA
- cells containing formula that refer to user-defined VBA function
- Fill VBA form with Cell values of an Excel sheet
- how are cell coordinates referenced on a clicked cell
- to see if text in a cell in a column is contained in any cell
- Moving data in the last cell of row to another column cell
- Action taken by Excel when a condition causes a cell's value
- Function needed to split the content of a cell intomany cells
- Function needed to split the content of a cell into many cells
- Finding and replacing the cell next to a cell with a certain string
- Copy Value produced by formula in cell C3 to cell D3
- Update a cell based on a DDE updated cell value
- active cell no longer advances to cell below
- A Paragraphs in one cells --> convert into a line in per cells
- Cell validation based on the contents of previous cell
- Copy cell contents to same cell on different worksheet if contains