PDA

View Full Version : [SOLVED] Remove the Index References table and continue to show the CF



akinkaraman
03-28-2015, 02:35 AM
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
03-28-2015, 10:12 AM
Does post#11 on thread "I need a conditional formatting formula (http://www.vbaexpress.com/forum/showthread.php?52129-I-need-a-Conditional-Formatting-formula)" not provide an answer to this problem?

akinkaraman
03-28-2015, 01:05 PM
I think I solved the problem with a working Conditional Formating formula at "I need a conditional formatting formula (http://www.vbaexpress.com/forum/showthread.php?52129-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)