Need help about excel formula (Conditional Formatting)

[ybr_15]

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:

1. If the value is 0 or blank then it is marked
2. If there are the same / duplicate values then marked except the first value

Please help, thank you

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

 

[FormR]

Hi, you can try this formula with the "use a formula to determine" method of CF.

=OR(B2=B1,B2=0)

Book5
	A	B	C	D	E	F	G
1	YTD	Categ. 1	Categ. 2	Categ. 3	Categ. 4	Categ. 5	Categ. 6
2	43862	3935554	163603	12845	0	113320	44553
3	43891	5542576	228321	12845	0	115840	207657
4	43922	6132596	270842	12845	336824	145190	207657
5	43952	7795626	321507	12845	1391168	155290	207657
6	43983	9520231	413932	12845	2802199	156810	328643
7	44013	11010925	424447	12845	3207172	156810	603340
8	44044	12104287	424447	12845	4399212	156810	901783
9	44075	12734468	424447	12845	4467020	156810	1184573
10	44105	12955248	431310	12845	4467020	157994	1184573
11	44136	13081636	431310	12845	4467020	194399	1310284
12	44166	13081636	431310	12845	4467020	194399	1310284
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:G12	Expression	=OR(B2=B1,B2=0)	text	NO

 

[ybr_15]

Hi, you can try this formula with the "use a formula to determine" method of CF.

=OR(B2=B1,B2=0)

Book5
	A	B	C	D	E	F	G
1	YTD	Categ. 1	Categ. 2	Categ. 3	Categ. 4	Categ. 5	Categ. 6
2	43862	3935554	163603	12845	0	113320	44553
3	43891	5542576	228321	12845	0	115840	207657
4	43922	6132596	270842	12845	336824	145190	207657
5	43952	7795626	321507	12845	1391168	155290	207657
6	43983	9520231	413932	12845	2802199	156810	328643
7	44013	11010925	424447	12845	3207172	156810	603340
8	44044	12104287	424447	12845	4399212	156810	901783
9	44075	12734468	424447	12845	4467020	156810	1184573
10	44105	12955248	431310	12845	4467020	157994	1184573
11	44136	13081636	431310	12845	4467020	194399	1310284
12	44166	13081636	431310	12845	4467020	194399	1310284
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:G12	Expression	=OR(B2=B1,B2=0)	text	NO

Hi, FormR
OMG, easy as that. I thought my head was blank. Thank you