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?