Quote Originally Posted by NBVC View Post
Assuming your are applying to column C starting at C16, then change the current conditional format in that column to:

"use a formula to determine which cells to format"

and apply formula:

=AND(C16<>"",OR(C16<SUMIF(INDEX(Data,0,1),$C$4,INDEX(Data,0,6)),C16>SUMIF(INDEX(Data,0,1),$C$4,INDEX(Data,0,5))))
Yep, that's the correct column. Sorry for leaving that bit out!

With the above formula, the text goes red and italic, but it stays red even when the number is within the "Max & Min".

That, or I am doing something wrong. (Probably me).

EDIT: I did it again and it worked perfectly! I knew I was the problem!

Thanks again for your brilliant help