Remove the Index References table and continue to show the CF

[akinkaraman]

Conditional Format at Index Table is showing the color cells with the help (formulas) of the Index Referanse table. However I must remove the Index Referense Table. Please help me to remove that Index Referance Table but continue to show the CF coloring at the Index Table.

(I want to remove between T38 and AH57)

You can change and use a different conditional format if you can continue to show the indexes in the below table in a different color like this too.

Thank you..

[Yongle]

Does post#11 on thread "I need a conditional formatting formula" not provide an answer to this problem?

[akinkaraman]

I think I solved the problem with a working Conditional Formating formula at "I need a conditional formatting formula"

=SUMPRODUCT(--(((($H$22:$AE$22=F$38)*$H$20:$AE$20)>=--LEFT($B39,SEARCH("-",$B39)-1))*(((($H$22:$AE$22=F$38)*$H$20:$AE$20)<=--MID($B39,SEARCH("-",$B39)+1,255)))>0)