Multiple Criteria Conditional Formatting

[Velven]

Hello Once again !

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 ?

 

[Yongle]

Get your formula to return the required TRUE/FALSE in another column before using CF

Put this formula in cell E1 and copy down
=AND(D1="Yes",B1<>"",A1<>"Wit")

Does it give you the correct results?
- it does what you asked for
- if not, correct the formula

When the formula is correct, select the whole of column B and apply the formula in CF
- check the results and delete formula in column E

 

[Velven]

Thank you so much !

I actually used the same And formula in the exact same way just now. But it wasnt working. I must've highlighted the wrong column

 

[Velven]

Hello !

Is it possible for me to do a not equals to Named range ? with that formula ?

Such as =AND(D1="Yes",B1<>"",A1<>"Fill in named range")

 

[Yongle]

Try this

=AND(D1="Yes",B1<>"",COUNTIF(MyNamedRange,A1)=0)

Assumes your named range
- is in a single column or row
- and contains values such as "Wit" "Redps" "Max" "Unl" "Dai"