I tried to explain in my earlier post but I may have just confused
things

If you apply this CF formula....

=(E1=$B2)*(E1<=$C2)

..... to a range, e.g. E1:AO1 it automatically adjusts across the
columns. so in G1 this becomes

=(G1=$B2)(G1=$C2) which is what you need to happen

(note that $B2 doesn't change because the $ fixes the column
reference)

You can't use

=($E$1=$B4)*($E$1<=$C4) because although it should work correctly in
E1 it won't work in F1:AO1

perhaps you want

=(E$1=$B4)*(E$1<=$C4)

this fixes the row reference but not the column reference


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503689