Posted to microsoft.public.excel.worksheet.functions
|
|
INDIRECT formula
I think i just figured out my own problem.. it was quite simple too :S
I just replaced I8 with $I8
Does this make sense?
"Morallis" wrote:
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
|