| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i find the last time i picked a winner | Excel Discussion (Misc queries) | |||
| Posts not getting picked up | Excel Discussion (Misc queries) | |||
| Have a running total when an option is picked. | Excel Worksheet Functions | |||
| If certain item is picked, then text added... | Excel Discussion (Misc queries) | |||
| Lookup with 3 criterias | Excel Worksheet Functions | |||
Threaded Mode
