Conditional formatting in Excel with #sk excel trick ||
It is conditional formatting can help make patterns and
trends in your data more apparent. To use it, you could create rules that
determine the format of cells based on their values, such as the following
monthly temperature data with cell colors tied to cell values in MS excel.
|
S.No |
Name |
Product Name |
Date |
Unites |
Rupees |
|
1 |
Rahul Kumar |
Noida |
2/2/2021 |
16 |
₹ 6,055.00 |
|
2 |
Mohan Kumar |
Samsung |
2/3/2021 |
18 |
₹ 6,703.00 |
|
3 |
Manish Kumar |
LG |
2/4/2021 |
13 |
₹ 9,340.00 |
|
4 |
Ankit Kumar |
Micromax |
2/5/2021 |
14 |
₹ 8,904.00 |
|
5 |
Raju Kumar |
Noida |
2/6/2021 |
17 |
₹ 6,634.00 |
|
6 |
Ranjan Singh |
Samsung |
2/7/2021 |
12 |
₹ 5,522.00 |
|
7 |
Rahul Kumar |
Noida |
2/2/2021 |
16 |
₹ 6,055.00 |
|
8 |
Mohan Kumar |
Samsung |
2/3/2021 |
18 |
₹ 6,703.00 |
|
9 |
Manish Kumar |
LG |
2/4/2021 |
13 |
₹ 9,340.00 |
|
10 |
Ankit Kumar |
Micromax |
2/5/2021 |
14 |
₹ 8,904.00 |
|
11 |
Raju Kumar |
Noida |
2/6/2021 |
17 |
₹ 6,634.00 |
|
12 |
Ranjan Singh |
Samsung |
2/7/2021 |
12 |
₹ 5,522.00 |
If you want to watch video how can use conditional formatting below link youtube.
https://www.youtube.com/watch?v=W3r-KI-7XZw
Example Step :-
1 Click on Home Tab > Go to Conditional formatting >you can choose condition what do you want to add condition in your Data in MS Excel below screen shot
Please find it.
No comments:
Post a Comment
if you have any doubt let me known will
give suggestion in this site
Thank you so much