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

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

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

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