IF(AND Statement in Conditional Formatting.

I need conditional formatting applied if

A5:A100 = *
J5:J100 =  Not Open*

Getting an error on below

="IF(AND(A5:A100>="*",J5:J100<>"Not Open*"),"TRUE", "FALSE")
Who is Participating?
Get rid of the " symbol between = and IF.

barry houdiniCommented:
Are you using * as a wildcard or a literal * ?

Can you give an example - what cell contents for A5 and J5 would trigger conditional formatting. If you want the row formatted when A5 is not blank and J5 begins with "Not Open" then you can't use wildcards (and you don't need IF) try like this

=AND(A5<>"",LEFT(J5,8)="Not Open")

If applied to the range A5:A100 or similar then Excel automatically adjusts the references - formula should reference first row only

regards, barry
mato01Author Commented:
Had to incorporate both solutions.  Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.