Hi, attached small Excel with 1 conditional format that doesn't do the job.
I want cells to be colored yellow if multiple AND condition is met.
Criteria described in file
who can help me?


thanx
R

Attached Files

CONDITIONING FORMATTING MULTI AND.xlsx (14.5 KB, 9 views)

How about
=AND($D2=3,AND($C2&$E2<>"WTO"))

Works, great.
I don't understand, why does this formula woks: =AND($D2=3,AND($C2&$E2<>"WTO"))
and this one doesn't ? =AND($D2=3,AND($C2<>"WT",$E2<>"O"))
thanx

In the sample workbook you attached, select I2
from the Formulas ribbon, in the Formula Auditing section, click Evaluate Formula.
Clicking the Evaluate button, Excel will evaluate the underlined portion of the formula
and you will see one step at a time how Excel works its way through the formula.
The conditional formatting is looking for a true result to apply formatting.

ok, great, thanx
r