Conditional format using "Indirect"

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?
 
D

djc

My other thread has been deleted.
can you show show write the solution once more?
sorry abt that
 
T

T. Valko

In your other post I asked you what does this mean in A1 reference style?

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

In other words, how would you write that 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

Similar Threads

Using Indirect for conditional Formating 3
Using SUM(INDIRECT()) 2
Deleting rows that meet criteria 3
Possible Indirect query 1
conditional formatting: multiple conditions with min 0
Indirect address 4
Conditional Formatting: Logical AND fails to work with INDIRECT(.. 5
conditional formatting, filtering then copying to another sheet 0

Top