Ignore/ Exception in conditional formatting

[greenteazen]

Hi

I need to create an exception or ignore rule to a column that has conditional formatting.

Let's say that's D and it highlights this column if red if the date is plus 15 work days from date in column C.

Column B has text in it relating to legal clauses and I need the formatting in D to ignore any rows that have say "clause 11.5" in column B. So in other words, the CF highlights all columns that are 15 working days from the date in C except if the item is a clause 11.5

Thank you

 

[arthurbr]

=AND($B1<>"clause 11.5",your date condition)

 

[greenteazen]

=AND($B1<>"clause 11.5",your date condition)

Hi
I tried that and it didn't work

 

[arthurbr]

Do the only contain "clause 11.5" or is this string part of a larger one? ( like 1234clause11.5 56")

 

[greenteazen]

Only clause 11.5

 

[arthurbr]

Any way you could post a sample sheet with the XLTOBB add-in?