PC Review


Reply
Thread Tools Rate Thread

conditional formatting: multiple conditions with min

 
 
Chris
Guest
Posts: n/a
 
      3rd Dec 2010
Hello,

I am using Excel 2007 and I am having an issue with conditional
formatting. I have 2 columns of data that I'm working with: Column "c"
which contains both names and some empty cells, and column "i" which
contains dates and some empty cells. If there's a name in column c
then there is definitely a corresponding date in the same row in
column i. However, there are sometimes blank cells in column c dates
that have dates in column i and some rows that have blanks in both c
and i. See the following example: (I apologize in advance if the
formatting is lost when I post this message)

Sue --- 10/1/2010
___ --- 10/1/2010
Joe --- 10/23/2010
___ --- _____
Bob --- 10/2/2010

I'm using the formula below as a conditional formatting rule to
highlight the rows where the date in column "i" is the minimum among
rows that have a name in column "c":

=$I4=MIN(IF($C$4:$C$50<>"", $I$4:$I$50))

It seems to work fine when I first enter the formula. However, if I
close and reopen my workbook, then the conditional formatting
highlights the wrong cells - it instead highlights only the cells in
row c that are blank (like the 4th row in my example above).
Strangely, if I then go to my conditional formatting rule, open it for
editing, then don't change anything but just click "ok" and "apply"
then the rule starts working again, the way I intended.

Since the formula works perfectly at times, I'm having trouble
determining if it is the cause or whether I have a wrong setting or
I'm encountering a bug. Can anyone please suggest a solution or
alternate way of approaching this task?

Thanks,

~Chris
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting: multiple conditions with min Chris Microsoft Excel Discussion 0 3rd Dec 2010 10:09 PM
Getting the min value that matches multiple conditions? jg70124 Microsoft Excel Discussion 8 12th Nov 2006 02:31 PM
GETRANDOM(min,max)((rand()%(int)(((max)+1)-(min)))+(min)) How in C# Roy Gourgi Microsoft C# .NET 6 18th Oct 2005 06:14 PM
Customise Calendar Time Scale e.g. 50 min, 50 min, 25 min, 30 min =?Utf-8?B?TWFyanVhbg==?= Microsoft Outlook Calendar 1 21st Sep 2005 06:53 AM
How to multiple conditions to validate more than 2 conditions to . =?Utf-8?B?Qmh1dmFuYSBHb3ZpbmQ=?= Microsoft Excel Worksheet Functions 1 28th Jan 2005 08:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:58 AM.