PC Review


Reply
Thread Tools Rate Thread

Conditional Formatting Based on Lookup into List

 
 
roscfb
Guest
Posts: n/a
 
      2nd Apr 2008
I have a list of people (with their company in column two) and an ever
updating list of visitors by date (column1) and visitor (column 2). I want
to put a conditional format on the company (in example "GE") field that will
change the color fill when a person is on the visitor list for a specific
day. Example Tues. April 8 2008.

I entered the day I am interested in, and the day after in a feild and had
the match function tell me their rows. Then I tried to get the OR(EXACT... )
function to look in a $FH$ <- put match function there. But this is not
correct.
'=OR(EXACT($Y18,$FU(MATCH($AI$82,$FH$1:$FH$863,0)):$FU$(MATCH($AI$83,$FH$1:$FH$863,0)))) Where $Y18 is the name column of the list of people.

Two part question;
1. If I can, how do I get a cell reference to work when I know the column
$FH, but the reference row ($82) changes when the external list is updated.
2. Alternative way to do what I am looking to do.
3. Extra Credit (function that returns date of next thursday or another
designated day after current date, preferably in a designated format).

Example list of names (this would be two columns)
Greg Jones......BAE
Joe Smith........GE
Susan Say.......GD

Example query updated list of visitors (also representing two columns.)
Visitor Date...............Visitor
Mon April 7 2008.........X
-................................Jane Doe
-................................Jack Black
-................................etc.
Tues April 8 2008 X
-................................Jane Doe
-................................John Tall
-................................Joe Smith
-................................etc.
Thur April 8 2008 X
-................................Jane Doe
-................................John Tall
-................................Charlie Bore
-................................etc.

Thank you - Zack

 
Reply With Quote
 
 
 
 
Herbert Seidenberg
Guest
Posts: n/a
 
      3rd Apr 2008
Using index(...area) formula
http://www.freefilehosting.net/download/3eghb
 
Reply With Quote
 
roscfb
Guest
Posts: n/a
 
      3rd Apr 2008
Thank you, I had tried that, but hopefully I errored and this reference will
help me find why.

"Herbert Seidenberg" wrote:

> Using index(...area) formula
> http://www.freefilehosting.net/download/3eghb
>

 
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 based on match to external list Dawn Mann Microsoft Excel Worksheet Functions 1 14th Apr 2010 11:28 AM
Conditional Formatting Based of Cells Based on Data Entry in anoth Jim Microsoft Excel Misc 3 11th Nov 2008 11:52 PM
Conditional formatting using lookup freestra@fastmail.fm Microsoft Excel Misc 1 28th Jul 2006 01:41 PM
conditional formatting using lookup up in a different sheet =?Utf-8?B?Q2hyaXNP?= Microsoft Excel Misc 10 2nd Feb 2006 10:40 AM
Conditional Formatting Based on Contents of a List Raeven Microsoft Excel Misc 3 26th Mar 2004 08:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:34 AM.