Hi,

I've got the same problem I'm trying to solve. I'm not quite sure what the
outcome was here, could someone explain this a little to me please.


The criteria were originally looking at the column and then colouring the
row according to the columns value.

=INDIRECT("I"&ROW())="T"
or
=INDIRECT("I"&ROW())="AB"
or
=INDIRECT("I"&ROW())="AC"

We need these merged into one single rule for the conditional formatting.

This doesnt seem to work:
=OR(INDIRECT("I"&ROW())="T",INDIRECT("I"&ROW())="A B",INDIRECT("I"&ROW())="AC")

And the line: =OR(I8="t",I8="u",I8="v") only refers to the specific cell I8

How do you add the three criteria [=INDIRECT("I"&ROW())="T",
=INDIRECT("I"&ROW())="AB" and =INDIRECT("I"&ROW())="AC"] into one rule so
that if the value in column I =T, AB or AC the whole row is highlighted with
the fill colour specified in the conditional formatting?

Sorry, Im quite new to this and honestly just learning slowly from forums
and other things I read. Im actually looking for some study material to work
through.

I hope someone can help me with my little problem for now though :)

Thanks.



"Don Guillett" wrote:

Just use this and copy the format
=OR(I8="t",I8="u",I8="v")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken" wrote in message
...
Hi again group!
A small question. I am using an INDIRECT formula for turning a row a
certain color, and it works well. How would one turn this formula into
a multiple criteria formula using the INDIRECT method:
=INDIRECT("I"&ROW())="T"
What I been trying to do is use an IF, OR, but I always get the
"error" message.
I've searched all over the internet for an example but no luck. The 3
criteria a
=INDIRECT("I"&ROW())="T"
or
=INDIRECT("I"&ROW())="AB"
or
=INDIRECT("I"&ROW())="AC"
I can accomplish this with 3 seperate rules, but it's just a little
"clunky".
It's really no big deal, just trying to learn something new....any
advice is greatly appreciated! My "Thanks" in advance!
Ken