Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 5th 09, 01:59 PM posted to microsoft.public.excel.newusers
djc djc is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 11
Default 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?

  #2   Report Post  
Old May 5th 09, 06:24 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default 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?



  #3   Report Post  
Old May 14th 09, 07:46 PM posted to microsoft.public.excel.newusers
djc djc is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 11
Default 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?

  #4   Report Post  
Old May 14th 09, 09:29 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default 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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
need help with a conditional format in regards to "date" input Fritter Excel Discussion (Misc queries) 1 September 25th 07 02:40 AM
Scroll Bar missing "Control" tab in "Format Properties" dialog box Peter Rooney Excel Discussion (Misc queries) 5 August 24th 06 05:36 PM
"Daisy-Chain" a conditional format? sixwest Excel Discussion (Misc queries) 2 May 12th 06 02:11 PM
Conditional Format Formula "includes" Cheri Excel Discussion (Misc queries) 4 April 13th 06 08:53 PM


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017