Conditional Format-Dispatch

Originally Posted by stevekirk

hi,

if k12 does not contain "egbd" anywhere in the text yet q12 has something in it then turn red
this is a sample of what could be in k12

Dispatch
Egbd/Biesse/Dis
Biesse/Dis
Egbd/Biesse/Saw/Dis
Biesse/Saw/Egbd/Dis



thanks
steve

Hi,

select K column, Conditional Format, Formula

=AND(Q1<>"",LEN(K1)<>LEN(SUBSTITUTE(K1,"Egbd","")))

hth
---

Originally Posted by stevekirk

bryan,

please see attached file i would have expected it to turn red in k12
steve

Hi,

try

=AND(Q1<>"",Q1<>"Edging",K1<>"",LEN(K1)=LEN(SUBSTITUTE(K1,"Egbd","")))


I misread it and you mistyped it (T in substitute)

hth
---