Conditional Formatting (CF) Depend On Multiple Criteria

[muhammad susanto]

hi all..
how to conditional formatting with condition like this:

Book1
	M	N
2	Status	value
3	Good	1
4	Excellent	100
5	Good	blank cell
6	Good	0
7	Other	100
Sheet1

note:
1. if status in col M3 down "Good or Excellent" and value in cell N3 down is >=0 ---->> so highlighted with red in cell M3 down
2. if status in col M3 down "Good or Excellent" but in col Value is no data (empty cell) ------>> do not highligted red in cell M3 down
3. if status excluded Good or Excellent ----->>> not highlighted anything


thank for your helping
.susanto

 

[Fluff]

How about

=AND(OR(M3="Good",M3="Excellent"),N3>0)

 

[muhammad susanto]

hi Fluff, thank you so much!!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[muhammad susanto]

hi fluff once again, how about thes case

Book1
	N
10	Value
11	-1
12	0
13	10
14	10000
15	empty cell
Sheet1

only 0 or empty cell - not highlighted red, the other number whatever is highlighted

 

[Fluff]

Try

=and(n10<>"",n10<>0)

 

[muhammad susanto]

hi fluff once again, how about thes case

Book1
	N
10	Value
11	-1
12	0
13	10
14	10000
15	empty cell
Sheet1

only 0 or empty cell - not highlighted red, the other number whatever is highlighted

hi fluff, i mistake about this should be like this

Book1
	E
4	Value
5	-1
6	0
7	TEXT
8	10
9	11
10	empty cell
Sheet2

criteria:
CELL HIGHLIGHTED IF CONTAINS NEGATIVE NUMBER, AS TEXT, VALUE BETWEEN 1-10
NUMBER 0 & EMPTY CELL NOT INCLUDED HIGHLIGHTED

 

[Fluff]

Are you going to make any more changes to your criteria, or is this it?

 

[muhammad susanto]

hi fluff, i,m sorry missing before not anymore, it just it not anymore
Edited criteria: more clear
1. Highlighted cell if contains < 10 or , as text,
2. Blank cell not highlighted
I think this my last post for this case.
Thanks Fluff

 

[Fluff]

Ok, how about

=AND(E5<>0,E5<>"",OR(ISTEXT(E5),E5<=10))