Conditional format using "Indirect"
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? |
Conditional format using "Indirect"
See your other post
-- Biff Microsoft Excel MVP "djc" wrote in message ... 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? |
Conditional format using "Indirect"
My other thread has been deleted.
can you show show write the solution once more? sorry abt that "djc" wrote: 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? |
Conditional format using "Indirect"
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? -- Biff Microsoft Excel MVP "djc" wrote in message ... My other thread has been deleted. can you show show write the solution once more? sorry abt that "djc" wrote: 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? |
All times are GMT +1. The time now is 04:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com