muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
i have table like this :
if criteria:
<=80% ---filled red color
80% till 100% --filled yellow color
>= 100% ---filled Green color
so far, i have make formula to different cell for each condition. This not efficient. How to make a single formula CF place in cell B3 (single formula) then copy down to another cell
it's possible give 1 formula to cover 3 condition/criteria?
anyone help would be appreciated...
susanto
i have table like this :
Book1 | |||
---|---|---|---|
B | |||
2 | data | ||
3 | 0,8 | ||
4 | 80% till 100% | ||
5 | >=100% | ||
Sheet1 |
if criteria:
<=80% ---filled red color
80% till 100% --filled yellow color
>= 100% ---filled Green color
so far, i have make formula to different cell for each condition. This not efficient. How to make a single formula CF place in cell B3 (single formula) then copy down to another cell
it's possible give 1 formula to cover 3 condition/criteria?
anyone help would be appreciated...
susanto