Conditional Formatting Issues...

[Dink37797]

Hi All,

I am having some issues with Conditional Formatting. I want to get a range of cells to be in colour when a separate range of cells' values are within two other cells. I.E I want F4:AX4 to be in colour when the range F3:AX3's values are between the values in cells D4 and E4. The current rule i have worked out is; =IF(AND($F$3:$AX$3>=MIN($D$4),$F$3:$AX$3<=MAX($E$4)),TRUE,FALSE)
But this doesn't seem to be working!

Please can anyone advise?!

Thanks in advance