Cannot get Conditional Formatting formula to work with wildcard characters.

[Oscar Martin]

Hi there. I'm having trouble getting a conditional formatting formula to work. You will find it in the attached spreadsheet; it is the only active conditional format in the Manage Rules tool. I want it to highlight the selected cells purple if the following conditions are met:

that the 'Mode' is equal to 'Road', AND the 'Booker' is equal to 'Interdean Brussels';

AND the 'Origin Agent' OR 'Destination Agent' fields have the word 'Interdean' in them.

I've nested the AND/OR functions together in the formula because I want the last two conditions to be either/or. But I think what is causing the problem is the wildcard character. I've never used it before and I'm not sure if I'm using it correctly. Basically if 'Origin Agent' or 'Destination Agent' have the word 'Interdean' in them I want them to qualify as part of the conditions.

Would really appreciate any help with this.

Oscar.

[popipipo]

http://www.excelforum.com/excel-form...ormatting.html

Maybe this will help

[sktneer]

May be this.......

Please Login or Register  to view this content.

[Oscar Martin]

Thanks Sktneer, that works perfectly. Thank you for your help.

[sktneer]

Glad to help you. Thanks for the feedback.