Conditional Formatting Formula Not Working Properly

Hi there,

I want this formula to switch on the conditional formating when the 'Shipment Type' = "Agent", the 'Service' is NOT "Door-to-Door", and the 'From/To' field = "To".

The formula I created works for the first two conditions, but fails when it comes to picking up "To" values.

Any help would be much appreciated.

Rgds,

Oscar.

In your conditional formatting formula, you need to change the IF to AND, like this:

=AND(O3<>"Door to Door",R3="Agent",W3="To")

Hope this helps.

Pete