Hello Once again !
My mind doesn't seems to function very well with conditional formatting criteria.
<tbody>
</tbody>
My logic will be the following.
On Column B:B
If(D:D"yes",A:A="<>Wit",B:B<>"")
Means D:D is Yes , A:A is not Wit , B:B is not blank , I want to highlight B:B.
Anything wrong with my formula ?
My mind doesn't seems to function very well with conditional formatting criteria.
A | B | C | D | |
1 | Request | De | Bo | Sal |
2 | Wit | Yes | ||
3 | Redp | Yes | ||
4 | Max | |||
5 | Unl | |||
6 | Dai | Yes |
<tbody>
</tbody>
My logic will be the following.
On Column B:B
If(D:D"yes",A:A="<>Wit",B:B<>"")
Means D:D is Yes , A:A is not Wit , B:B is not blank , I want to highlight B:B.
Anything wrong with my formula ?