View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steveB steveB is offline
external usenet poster
 
Posts: 30
Default Conditional Formatting using two formula conditions

Dan,

Just a minor alteration of what you already have:

=And(AD3<"",AE3="")

--

steveB

(Remove 'NOSPAM' from email address if contacting me direct)


"Dan" wrote in message
...
Basically, I want to apply conditional formatting like so:
IF (AD3<"") AND (AE3="") THEN

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