এক্সেল কনডিশনাল ফর্মেটিং অনুশীলন ফাইল.xlsx

	B	C	D	E	F	G	H	I	J
1	Excel Conditional Formatting
2
3	Name	Designatoin	Basic	H_Rent	M_All	TA_DA	IN_Tax	P_Fund	Net Salary
4	Rahim	Chairman	55000	22000	8250	5500	2750	2750	85250
5	Jamal	MD	48000	19200	7200	4800	2400	2400	74400
6	Karim	Manager	35000	14000	5250	3500	1750	1750	54250
7	Sattar	Asst. Manager	28000	11200	4200	2800	1400	1400	43400
8	Jahangir	Operator	15000	6000	2250	1500	750	750	23250
9	Himel	Operator	15500	6200	2325	1550	775	775	24025
10	Konok	Operator	15000	6000	2250	1500	750	750	23250
11	Sultan	Peon	10000	4000	1500	1000	500	500	15500
12	Multan	Operator	9500	3800	1425	950	475	475	14725
13	Panna	Supervisor	20000	8000	3000	2000	1000	1000	31000
14	Kabir	Operator	10000	4000	1500	1000	500	500	15500
15	Himel	Operator	10000	4000	1500	1000	500	500	15500
16	Rahim	Mali	8000	3200	1200	800	400	400	12400
17	Karim	Operator	11000	4400	1650	1100	550	550	17050
18	Panna	Operator	10500	4200	1575	1050	525	525	16275
19	Kabir	Operator	15000	6000	2250	1500	750	750	23250
20	Multan	Operator	12000	4800	1800	1200	600	600	18600
21	Jamal	Supervisor	19000	7600	2850	1900	950	950	29450
22	Rahim	Operator	9000	3600	1350	900	450	450	13950
23	Himel	Operator	11200	4480	1680	1120	560	560	17360
24	Panna	Operator	9000	3600	1350	900	450	450	13950
25	Kabir	Operator	15000	6000	2250	1500	750	750	23250
26	Rahim	Operator	9000	3600	1350	900	450	450	13950
27	Jamal	Mali	9000	3600	1350	900	450	450	13950
28	Karim	Peon	8000	3200	1200	800	400	400	12400
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100