muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
how to conditional formatting with condition like this:
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
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