Conditional Formatting with two Spreadsheets

G

Gos-C

Hi,

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

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

Any suggestion?

Thanks,
Gos-
 
G

Guest

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,
 
G

Gos-C

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

Gos-
 
D

Dave Peterson

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
 
G

Gos-C

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

Thank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing two spreadsheets 2
Multiple criteria for moving a row to new spreadsheet 1
Workbook takes a long time to calculate 5
Excel vba query - data integrity 9
VBA dynamically format Row1 2
Conditional Formatting - Comparative Versus Other Cells 4
Conditional Formatting 1
Get input from spreadsheet control to server for processing 1

Top