Thread: [Solved] Indirect not working in Conditional Formatting
View Single Post
 
Old 06-18-2016, 06:35 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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
Attached Files
File Type: xlsx _Indirect-ConditionalFormatting_3.xlsx (14.0 KB, 9 views)
Reply With Quote