Conditional Formatting using two formula conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Basically, I want to apply conditional formatting like so
IF (AD3<>"") AND (AE3="") THE

so, two linked conditions, is there a way to do this with conditional formatting's "formula is"
=AD3<>"" works fine, but it's getting two conditions to work that is the problem

Thanks
 
Dan,

Just a minor alteration of what you already have:

=And(AD3<>"",AE3="")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting with VBA 4
Excel Conditional Formatting Removal 7
Conditional Formatting 1
conditional formatting suddenly disabled 1
recognizing conditional formatting with VBA 3
Conditional Formating: MAX & MIN 3
Conditional Formatting Weirdness 2
Conditional formatting if condition of an if statement is true and astring value is displayed 1

Back
Top