Using Indirect for conditional Formating

D

djc

I have 2 worksheet 1st destination(IR) 2nd source (Amt)
I would like to have (IR sheet column highlighted if source (AMT) contains
number.
I have used
indirect("'ir'!F)&ROW(F3))>0 and this command works if data is contained
in rows.
How can i incorporate in column instead of rows?
I have Tried
indirect("'ir'!3<-(starting row)&Column(F3))>0
and i have failed to trigger CF.
Can anyone help?
 
G

Glenn

djc said:
I have 2 worksheet 1st destination(IR) 2nd source (Amt)
I would like to have (IR sheet column highlighted if source (AMT) contains
number.
I have used
indirect("'ir'!F)&ROW(F3))>0 and this command works if data is contained
in rows.
How can i incorporate in column instead of rows?
I have Tried
indirect("'ir'!3<-(starting row)&Column(F3))>0
and i have failed to trigger CF.
Can anyone help?


Use the "R1C1" option of INDIRECT(). Something like this:


=INDIRECT("'ir'!R3C"&COLUMN(F3),FALSE)>0
 
S

Sheeloo

Use
=indirect("string",FALSE)>0

where string is the ref in R1C1 style built using a formula like you are
trying to do.

FALSE argument expects the reference in R1C1 style which is easier to build.
eg. to refer to IR!A3
string would be
IR!R3C1
 
T

T. Valko

indirect("'ir'!3<-(starting row)&Column(F3))

What does that mean in A1 reference style?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top