#1
|
|||
|
|||
Indirect not working in Conditional Formatting
The "Indirect" formula doesn't work in the Conditional Formatting in Columns B & C (Version: 2007), but it works in Excel 2010.
Please see the attached file. _Indirect-ConditionalFormatting.xlsx Thank you. |
#2
|
|||
|
|||
Is it like shown here?
|
#3
|
|||
|
|||
Pardon? What is the meaning of "Is it like shown here?"?
|
#4
|
|||
|
|||
Like shown in the attached file Sheet2!D26
|
#5
|
||||
|
||||
@tinfanide
Please do not quote entire posts unnecessarily. They are just clutter and make threads hard to read. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
@xor
But why: Code:
INDIRECT("S"&'1A'!$B$8&"_Tbl[@Group]") ' S1A1A_Tbl |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
It would be nice of you if you gave just a tiny response as to whether you could use my answer, and if not - why?
Lack of any response is about the worst of all. As an Expert I think you should know that. |
#9
|
|||
|
|||
I'm sorry. It's not proper manner to reply so late to people like you helping random guys. I'm really sorry work's been so busy that I could hardly post here. Really sorry.
A few days ago I tested it in the workplace. The problem is at home (Excel 2010) it (conditional formatting) works but in Excel 2007, the formatting doesn't. |
#10
|
|||
|
|||
Can you use the attached which has been set up in Excel 2007.
|
#11
|
|||
|
|||
There was an error in the conditional formatting formula so please use the attached file instead.
|
#12
|
|||
|
|||
Are you talking about the red highlighted cell? If so, then it works in my workplace (Excel 2007). Thank you for your solution.
It seems that structured referencing does not work in the conditional formatting in Excel 2007. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting | grexcelman | Excel | 8 | 01-12-2015 10:27 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting | teza2k06 | Excel | 3 | 01-19-2014 02:34 AM |
Conditional Formatting. | Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
Conditional formatting with AND, OR | Lucky | Excel | 2 | 10-03-2011 11:41 PM |