Combining INDIRECT
You can combine these conditions with AND, as in:
=AND(Indirect(...),Indirect(...),Indirect(...),Ind irect(...))
Does this help?
Regards,
Fred.
"Ken" wrote in message
...
Hi Group,
I have the following formula used in conditional formatting:
=INDIRECT("I"&ROW())="AB"
=INDIRECT("I"&ROW())="A"
=INDIRECT("I"&ROW())="AC"
=INDIRECT("I"&ROW())="T"
I have 4 different conditions so I have 4 different CF rules. Can they
be combined into one? Thanks in advance for any help!
Ken
|