Hi, I have data like in the following table and want to mark it with Conditional Formatting (yellow highlight). The criteria used in each Category column (C, D ,,, to H) are:
- If the value is 0 or blank then it is marked
- If there are the same / duplicate values then marked except the first value
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | |||
2 | YTD | Categ. 1 | Categ. 2 | Categ. 3 | Categ. 4 | Categ. 5 | Categ. 6 | ||
3 | Feb-20 | 3,935,554 | 163,603 | 12,845 | - | 113,320 | 44,553 | ||
4 | Mar-20 | 5,542,576 | 228,321 | 12,845 | - | 115,840 | 207,657 | ||
5 | Apr-20 | 6,132,596 | 270,842 | 12,845 | 336,824 | 145,190 | 207,657 | ||
6 | Mei-20 | 7,795,626 | 321,507 | 12,845 | 1,391,168 | 155,290 | 207,657 | ||
7 | Jun-20 | 9,520,231 | 413,932 | 12,845 | 2,802,199 | 156,810 | 328,643 | ||
8 | Jul-20 | 11,010,925 | 424,447 | 12,845 | 3,207,172 | 156,810 | 603,340 | ||
9 | Agu-20 | 12,104,287 | 424,447 | 12,845 | 4,399,212 | 156,810 | 901,783 | ||
10 | Sep-20 | 12,734,468 | 424,447 | 12,845 | 4,467,020 | 156,810 | 1,184,573 | ||
11 | Okt-20 | 12,955,248 | 431,310 | 12,845 | 4,467,020 | 157,994 | 1,184,573 | ||
12 | Nov-20 | 13,081,636 | 431,310 | 12,845 | 4,467,020 | 194,399 | 1,310,284 | ||
13 | Des-20 | 13,081,636 | 431,310 | 12,845 | 4,467,020 | 194,399 | 1,310,284 | ||
Sheet1 |