Conditional formatting II
 

my condition is of the form AND(A1=B1,A1=C1) - thanks Barb and Pete. But -
instead of just one cell per column, I need to look for A1 in ranges
R1B1:R150B1 and R1C1:R150C1, respectively. What function, or construct,
should I use?

Conditional formatting II
 

AND(ISNUMBER(MATCH(A1,B1:B150,0)),ISNUMBER(MATCH(A 1,C1:C150,0)))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mac" wrote in message
...
my condition is of the form AND(A1=B1,A1=C1) - thanks Barb and Pete. But -
instead of just one cell per column, I need to look for A1 in ranges
R1B1:R150B1 and R1C1:R150C1, respectively. What function, or construct,
should I use?

Conditional formatting II
 

Excellent! Thank you. One more point - instead of saying explicitly A1, how
do I reference 'this' - value in the current cell? I am going to populate
this formula throughout a large region...

"Bob Phillips" wrote:

AND(ISNUMBER(MATCH(A1,B1:B150,0)),ISNUMBER(MATCH(A 1,C1:C150,0)))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mac" wrote in message
...
my condition is of the form AND(A1=B1,A1=C1) - thanks Barb and Pete. But -
instead of just one cell per column, I need to look for A1 in ranges
R1B1:R150B1 and R1C1:R150C1, respectively. What function, or construct,
should I use?

Conditional formatting II
 

When you select a range (say A1:A100) and use a Conditional Format formula
such as =A110
then it appliers to all selected cells since A1 is a relative address.
So select you range use Bob's formula but make some absolute references as
in
AND(ISNUMBER(MATCH(A1,$B$1:$B$150,0)),ISNUMBER(MAT CH(A1,$C$1:$C$150,0)))
and all should be well
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mac" wrote in message
...
Excellent! Thank you. One more point - instead of saying explicitly A1,
how
do I reference 'this' - value in the current cell? I am going to populate
this formula throughout a large region...

"Bob Phillips" wrote:

AND(ISNUMBER(MATCH(A1,B1:B150,0)),ISNUMBER(MATCH(A 1,C1:C150,0)))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Mac" wrote in message
...
my condition is of the form AND(A1=B1,A1=C1) - thanks Barb and Pete.
But -
instead of just one cell per column, I need to look for A1 in ranges
R1B1:R150B1 and R1C1:R150C1, respectively. What function, or construct,
should I use?

Conditional formatting II
 

....solved.:-)

"Mac" wrote:

Excellent! Thank you. One more point - instead of saying explicitly A1, how
do I reference 'this' - value in the current cell? I am going to populate
this formula throughout a large region...

"Bob Phillips" wrote:

AND(ISNUMBER(MATCH(A1,B1:B150,0)),ISNUMBER(MATCH(A 1,C1:C150,0)))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mac" wrote in message
...
my condition is of the form AND(A1=B1,A1=C1) - thanks Barb and Pete. But -
instead of just one cell per column, I need to look for A1 in ranges
R1B1:R150B1 and R1C1:R150C1, respectively. What function, or construct,
should I use?