Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
need help with a conditional format in regards to "date" input | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
"Daisy-Chain" a conditional format? | Excel Discussion (Misc queries) | |||
Conditional Format Formula "includes" | Excel Discussion (Misc queries) |