![]() |
|
#1
|
|||
|
|||
![]()
Is it like shown here?
|
#2
|
|||
|
|||
![]()
Pardon? What is the meaning of "Is it like shown here?"?
|
#3
|
|||
|
|||
![]()
@xor
But why: Code:
INDIRECT("S"&'1A'!$B$8&"_Tbl[@Group]") ' S1A1A_Tbl |
#4
|
|||
|
|||
![]()
I don't know what you are talking about.
Have now made the conditional formatting in sheet 1A!E2:E6 and the formula is like follows: =(INDIRECT("S"&$B$8&"_Tbl[@Group]")<>"a")*(INDIRECT("S"&$B$8&"_Tbl[@Group]")<>"b")=1 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting | grexcelman | Excel | 8 | 01-12-2015 10:27 AM |
![]() |
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting | teza2k06 | Excel | 3 | 01-19-2014 02:34 AM |
![]() |
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
![]() |
Lucky | Excel | 2 | 10-03-2011 11:41 PM |