| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting problem
This has me completely stumped!
Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting problem
P.S.
I know this can be done with different formulas. Please don't offer other formulas. I want to know why *this* formula isn't working! Thank you Biff "T. Valko" wrote in message ... This has me completely stumped! Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting problem
Biff,
Won't the INDIRECT part produce a circular reference (or have I completely misunderstood how the CF is applied.... not for the first time!!!). If so, it won't work. "T. Valko" wrote: P.S. I know this can be done with different formulas. Please don't offer other formulas. I want to know why *this* formula isn't working! Thank you Biff "T. Valko" wrote in message ... This has me completely stumped! Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting problem
Biff,
When I enter numbers into the Address function, it works, but doesn't when I use ROW() and/or COLUMN(). Perhaps it is too nested for CF. Bernie "T. Valko" wrote in message ... This has me completely stumped! Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting problem
No, not when used if CF. If it were a cell formula then yes, it would be a
circular reference. I tried this last night and it worked! The same formula less the COUNT portion. I did this in a reply to a post in the .misc group. Biff "Toppers" wrote in message ... Biff, Won't the INDIRECT part produce a circular reference (or have I completely misunderstood how the CF is applied.... not for the first time!!!). If so, it won't work. "T. Valko" wrote: P.S. I know this can be done with different formulas. Please don't offer other formulas. I want to know why *this* formula isn't working! Thank you Biff "T. Valko" wrote in message ... This has me completely stumped! Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting problem
Well, I'm making progress!
If I remove the AND(COUNT(......) it works. =INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$19,N$ 31) Screencap: http://img248.imageshack.us/img248/6...roblemafj9.jpg As you can see it does work with empty row/column arguments. Here's the post from last night: http://tinyurl.com/ysdmax I've used much more complex formulas in CF than these! I hate not knowing what's causing this to not work. Biff "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Biff, When I enter numbers into the Address function, it works, but doesn't when I use ROW() and/or COLUMN(). Perhaps it is too nested for CF. Bernie "T. Valko" wrote in message ... This has me completely stumped! Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting problem
Interesting, both these works
=(COUNT(N$31,N$43,N$55)0)*(INDIRECT(ADDRESS(ROW() ,COLUMN()))=MIN(N$7,N$19,N$31))=1 =AND(COUNT(N$7,N$19,N$31)0,(INDIRECT(INDEX(ADDRES S(ROW(),COLUMN()),1,1))=MIN(N$7,N$19,N$31))) Maybe Harlan can shred some light on this? -- Regards, Peo Sjoblom "T. Valko" wrote in message ... Well, I'm making progress! If I remove the AND(COUNT(......) it works. =INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$19,N$ 31) Screencap: http://img248.imageshack.us/img248/6...roblemafj9.jpg As you can see it does work with empty row/column arguments. Here's the post from last night: http://tinyurl.com/ysdmax I've used much more complex formulas in CF than these! I hate not knowing what's causing this to not work. Biff "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Biff, When I enter numbers into the Address function, it works, but doesn't when I use ROW() and/or COLUMN(). Perhaps it is too nested for CF. Bernie "T. Valko" wrote in message ... This has me completely stumped! Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting problem
Biff,
It doesn't work if you just wrap it in an AND statement, although I can see no reason why it shouldn't.. =IF(AND(A1=123),"T","F") works as a normal formula =AND(INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$1 9,N$31)) doesn't work in CF .....????? "T. Valko" wrote: Well, I'm making progress! If I remove the AND(COUNT(......) it works. =INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$19,N$ 31) Screencap: http://img248.imageshack.us/img248/6...roblemafj9.jpg As you can see it does work with empty row/column arguments. Here's the post from last night: http://tinyurl.com/ysdmax I've used much more complex formulas in CF than these! I hate not knowing what's causing this to not work. Biff "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Biff, When I enter numbers into the Address function, it works, but doesn't when I use ROW() and/or COLUMN(). Perhaps it is too nested for CF. Bernie "T. Valko" wrote in message ... This has me completely stumped! Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting problem
It doesn't work if you just wrap it in an AND statement,
although I can see no reason why it shouldn't.. Yeah, that's where I'm at! I can see no reason why it shouldn't work. Biff "Toppers" wrote in message ... Biff, It doesn't work if you just wrap it in an AND statement, although I can see no reason why it shouldn't.. =IF(AND(A1=123),"T","F") works as a normal formula =AND(INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$1 9,N$31)) doesn't work in CF ....????? "T. Valko" wrote: Well, I'm making progress! If I remove the AND(COUNT(......) it works. =INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$19,N$ 31) Screencap: http://img248.imageshack.us/img248/6...roblemafj9.jpg As you can see it does work with empty row/column arguments. Here's the post from last night: http://tinyurl.com/ysdmax I've used much more complex formulas in CF than these! I hate not knowing what's causing this to not work. Biff "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Biff, When I enter numbers into the Address function, it works, but doesn't when I use ROW() and/or COLUMN(). Perhaps it is too nested for CF. Bernie "T. Valko" wrote in message ... This has me completely stumped! Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting problem
hi there
ive tried these on CF at cell N7 =COUNT($N$7,$N$19,$N$31)*(N7=MIN($N$7,$N$19,$N$31) ) =AND(COUNT($N$7,$N$19,$N$31)0,(N7=MIN($N$7,$N$19, $N$31))) i also like to know why your formula dont work with both indirect and count function inside an *and*... regards, driller -- ***** birds of the same feather flock together.. "T. Valko" wrote: It doesn't work if you just wrap it in an AND statement, although I can see no reason why it shouldn't.. Yeah, that's where I'm at! I can see no reason why it shouldn't work. Biff "Toppers" wrote in message ... Biff, It doesn't work if you just wrap it in an AND statement, although I can see no reason why it shouldn't.. =IF(AND(A1=123),"T","F") works as a normal formula =AND(INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$1 9,N$31)) doesn't work in CF ....????? "T. Valko" wrote: Well, I'm making progress! If I remove the AND(COUNT(......) it works. =INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$19,N$ 31) Screencap: http://img248.imageshack.us/img248/6...roblemafj9.jpg As you can see it does work with empty row/column arguments. Here's the post from last night: http://tinyurl.com/ysdmax I've used much more complex formulas in CF than these! I hate not knowing what's causing this to not work. Biff "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Biff, When I enter numbers into the Address function, it works, but doesn't when I use ROW() and/or COLUMN(). Perhaps it is too nested for CF. Bernie "T. Valko" wrote in message ... This has me completely stumped! Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting problem
There are better formulas to use for this but this is part of the learning
process. The formula I tried isn't the best formula for this but I was experimenting. That formula is both logically and syntactically correct but it doesn't work. I would just like to know why! Biff "driller" wrote in message ... hi there ive tried these on CF at cell N7 =COUNT($N$7,$N$19,$N$31)*(N7=MIN($N$7,$N$19,$N$31) ) =AND(COUNT($N$7,$N$19,$N$31)0,(N7=MIN($N$7,$N$19, $N$31))) i also like to know why your formula dont work with both indirect and count function inside an *and*... regards, driller -- ***** birds of the same feather flock together.. "T. Valko" wrote: It doesn't work if you just wrap it in an AND statement, although I can see no reason why it shouldn't.. Yeah, that's where I'm at! I can see no reason why it shouldn't work. Biff "Toppers" wrote in message ... Biff, It doesn't work if you just wrap it in an AND statement, although I can see no reason why it shouldn't.. =IF(AND(A1=123),"T","F") works as a normal formula =AND(INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$1 9,N$31)) doesn't work in CF ....????? "T. Valko" wrote: Well, I'm making progress! If I remove the AND(COUNT(......) it works. =INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$19,N$ 31) Screencap: http://img248.imageshack.us/img248/6...roblemafj9.jpg As you can see it does work with empty row/column arguments. Here's the post from last night: http://tinyurl.com/ysdmax I've used much more complex formulas in CF than these! I hate not knowing what's causing this to not work. Biff "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Biff, When I enter numbers into the Address function, it works, but doesn't when I use ROW() and/or COLUMN(). Perhaps it is too nested for CF. Bernie "T. Valko" wrote in message ... This has me completely stumped! Why doesn't this conditional formatting get applied? Screencap: http://img522.imageshack.us/img522/8...problembt4.jpg The formula is correct. I've put the same formula in column O (adjusted for the column offset) and as you can see, evaluates to TRUE. That highlighted 23 is also conditionally formatted. Just a test to make sure that *any* CF is working. Thanks Biff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem conditional formatting? | Excel Worksheet Functions | |||
| Problem with conditional formatting | Excel Worksheet Functions | |||
| Problem with Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting Problem | Excel Discussion (Misc queries) | |||
| Conditional Formatting problem | Excel Discussion (Misc queries) | |||
Linear Mode
