Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 16

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions	Mike Barlow	Excel Worksheet Functions	7	May 21st 23 07:42 PM
Indirect	waldorf	Excel Worksheet Functions	5	August 26th 08 08:15 PM
Help with INDIRECT	Anita Taylor	Excel Worksheet Functions	5	March 6th 08 12:50 AM
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4)	Dave F[_2_]	Excel Discussion (Misc queries)	3	September 20th 07 08:36 PM
Indirect	jcastellano	Excel Worksheet Functions	5	March 7th 06 06:41 PM

All times are GMT +1. The time now is 07:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us