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.
Bookmarks