LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 73
Default Conditional Formatting

First thank you for your help.
I'm trying to use conditional formatting to highlight the cell that is the
lowest among these cells and I tried using this formula.
=$BM16=MIN(IF($BK16,BM16,BO16,$BQ160,$BK16,BM16,B O16,$BQ16))
I get an error because I guess you cannot use every other cell in the formula.
I cannot use a range because each alternating cell has a dollar value while
the other cells represent weeks from 1 - 52.

An example of the data is:
BK BL BM BN BO BP BQ BR
$11.340 1 $7.700 2 $10.722 2 $6.000 39

I'm trying to get this result:
The cell that should be highlighted is BQ16

If I use =$BM16=MIN(IF($BK16:$BR160,$BK16:$BR16)) it works but highlights
the wrong cell, it would highlight BL16.

Again thank you for your help
Joe

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Conditional Formatting Icon Sets The Rook[_2_] Excel Discussion (Misc queries) 3 March 7th 09 08:48 PM
Formatting cells in a column with conditional formatting? shamor Excel Discussion (Misc queries) 8 May 19th 08 10:11 PM
Protect Cell Formatting including Conditional Formatting Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 05:32 PM
conditional Formatting based on cell formatting Totom Excel Worksheet Functions 3 January 20th 07 02:02 PM
Conditional Formatting that will display conditional data BrainFart Excel Worksheet Functions 1 September 13th 05 05:45 PM


All times are GMT +1. The time now is 01:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"