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

 

[muhammad susanto]

Thanks you Fluff

 

[Fluff]

You're welcome & thanks for the feedback.