| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you have 2 criterias be picked up in a lookup?
see your other post
-- Biff Microsoft Excel MVP "N. Vu" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you have 2 criterias be picked up in a lookup?
Plus Dim lL as Long For iL = 1 to 50 Call Do_Lash("N. Vu") Next lL for posting to two sub-forums without at least mentioning that you did... :Bgr -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111555 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you have 2 criterias be picked up in a lookup?
LOL!
-- Biff Microsoft Excel MVP "jamescox" wrote in message ... Plus Dim lL as Long For iL = 1 to 50 Call Do_Lash("N. Vu") Next lL for posting to two sub-forums without at least mentioning that you did... :Bgr -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111555 |
| Reply |
| 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 | |||
Linear Mode
