how do you have 2 criterias be picked up in a lookup?

N

N. Vu

How do you highlight a row where the following 2 criteria are met:

There are 2 columns with different numbers in each column, say about 100
rows of data. How to create a lookup/conditioning formatting in order to
Highlight the row only if BOTH columns meet the following criteria:
1. Column A value equals 38
AND 2. Column B value is greater than 0.25
 

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

how do you have 2 criterias be picked up in a lookup? 5
MACRO: Add formula's across row if criteria is met 3
Using Lookup with GT and LT Columns 1
lookup and return column number 2
Sort then lookup 1
lookup using column headers and row headers 1
lookup in a matrix 2
How to highlight the lowest valued cell in a column in Excel 2003 2

Top