View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
N. Vu N. Vu is offline
external usenet poster
 
Posts: 3
Default how do you have 2 criterias be picked up in a lookup?

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