About conditional formatting

[shohagmpl]

I want make color each materials last three or less than three value.

Materials Name	Value
A	1
A	2
A	3
A	4
A	5
A	6
B	1
B	2
B	3
B	4
C	1
C	2
C	3
D	1
D	2
E	1
E	2
E	3
E	4
E	5
F	1
F	2
G	1
G	2
G	3
G	4
G	5

 

[BobUmlas]

Select all the cells in column A (with data), and use conditional formula:
(assumes A1 is the active cell) (yes, "Materials Name"):
=$B1<3
Then click Format, and pick a color.

 

[Fluff]

How about

+Fluff New.xlsm
	A	B
1	Materials Name	Value
2	A	1
3	A	2
4	A	3
5	A	4
6	A	5
7	A	6
8	B	1
9	B	2
10	B	3
11	B	4
12	C	1
13	C	2
14	C	3
15	D	1
16	D	2
17	E	1
18	E	2
19	E	3
20	E	4
21	E	5
22	F	1
23	F	2
24	G	1
25	G	2
26	G	3
27	G	4
28	G	5
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B28	Expression	=COUNTIF($A$2:$A2,$A2)>COUNTIF($A:$A,$A2)-3	text	NO