View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default If(And for Conditional Formating

Just use the AND to return TRUE when the condition should be applied...
=and((a1b1),(a1<100)).

"Ronbo" wrote:

1. Is it possible to add a "If(And function" to condition(1) in conditional
formating?

2. If so what is the syntax?

What I am using, but does not work (in all cases) is;
If(And(a1b1),(a1<100))

Using (what I believe to be the correct syntax) is not exceptable:
If(And(a1b1,a1<100))