Conditional Formatting with two Spreadsheets
 

Hi,

I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup
column E of Spreadsheet2 on Spreadsheet1, and if column K of
Spreadsheet1 is greater than or equal to 1, then highlight the row in
Spreadsheet2.

VLOOKUP won't work because the numbers are not in order.

Any suggestion?

Thanks,
Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=376278

Only addressing the vlookup issue.
The 4th argument of vlookup (range_lookup) should be FALSE, then vlookup
will work fine even w/o the data being in order.
HTH,
--
Gary Brown

Please rate this posting if it is helpful to you.


"Gos-C" wrote:


Hi,

I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup
column E of Spreadsheet2 on Spreadsheet1, and if column K of
Spreadsheet1 is greater than or equal to 1, then highlight the row in
Spreadsheet2.

VLOOKUP won't work because the numbers are not in order.

Any suggestion?

Thanks,
Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=376278

I named F5:K104 of sheet1 RangeMayWk1, then entered
=VLOOKUP(E5,RangeMayWk1,6,False) as the conditional formatting formula,
but it didn't work. Any suggestion?

Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=376278

When you say 'it didn't work', what do you mean?
--
Gary Brown

Please rate this posting if it is helpful to you.


"Gos-C" wrote:


I named F5:K104 of sheet1 RangeMayWk1, then entered
=VLOOKUP(E5,RangeMayWk1,6,False) as the conditional formatting formula,
but it didn't work. Any suggestion?

Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=376278

Still seeking help . . .

Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=376278

You didn't answer Gary's question.

But if you want to check to see if that value is 1, then shouldn't that be
part of your CF formula?

=VLOOKUP(E5,RangeMayWk1,6,FALSE)1



Gos-C wrote:

Still seeking help . . .

Gos-C

--
Gos-C

------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=376278

--

Dave Peterson

May I send a sample of my work book to someone who would like to help me
with the code?

Thanks


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=376278