"AND" function in conditional formating not working

[John19]

I have a formula for conditional formatting "=$J5:$J305=LEFT($AT$7,4)+0" which is working but when I

amend it to include an AND function to "=AND($J5:$J305=LEFT($AT$7,4)+0,$G$2="TRY")" it does not work?

I just want the formatting to apply to those cells if another condition is TRUE i.e cell G2 = "TRY"

please can someone help

thank you
Untitled.jpg
Untitled2.jpg

I have also posted this question at:
http://www.mrexcel.com/forum/newthre...newthread&f=10

[gmr4evr1]

I think you need an IF instead of AND
Try

Please Login or Register  to view this content.

[salim ali]

use this formula in conditional format after that you select the range j5:j305 with j5 is the active cell

Please Login or Register  to view this content.

[John19]

it worked perfect
thank you

solved