Can Conditional Formatting Formulas have Multiple Statements

[Coors]

Can you have IF and AND statements in Conditional formatting formulas?

I put this and I get an error: =IF(AND($G5=""($H5=<>"")) I was testing the water for adding and OR statment also. I really want if cell G5 is blank and cell H5 or I5 has text, then G5 should be red.

Thanks,

[NBVC]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[ChemistB]

You're missing a comma between your AND arguments.

[Coors]

You're missing a comma between your AND arguments.

How?

And can I include an OR statment for I5?

[NBVC]

Try

=AND(G5="",OR(H5<>"",I5<>""))

[Coors]

That works. I have another condition affecting I5.

Thanks for the help

[NBVC]

That works. I have another condition affecting I5.

Thanks for the help

Not sure what/if there is a question here?

[Coors]

I need to decode my data and attach the file.....it has to many conditions

[Coors]

Here is the attached file.

Basically everything works, but when you go back and delete g5 the conditions do not work.

[NBVC]

I am not sure what is different than what I helped you on in other threads of similar requests...

... what are the actual conditions you need to be met... in order of application.

[Coors]

If you play around with the file. You fill all of row 5 out and then go back and delete G5 and A5:F5 will stay green as if it is complete. I want A5:F5 to be green only if all cells A5:I5 are complete.

[NBVC]

Select the cells in cells that only have that one condition and apply CF formula:

=COUNTBLANK($A5:$I5)=0

click Format and choose Green

Then Select H5 and delete Condition 1.

Then add new condition and put formula above and choose Green

Repeat for I5

[Coors]

Solved.......Thanks