View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken[_4_] Ken[_4_] is offline
external usenet poster
 
Posts: 16
Default Combining INDIRECT

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