Greater than
In this scenario, you are analyzing the inventory in your warehouse and you would like to see which items are over-stocked.
You have decided that any items that you have more than 300 of need to be marked down with a "clearance" price and you need to show which items these are.
यह अभ्यास पाठ्यक्रम का हिस्सा है
Google Sheets में Conditional Formatting
अभ्यास निर्देश
- Highlight range
B2toB16and add a new rule in the conditional formatting window to the right. - Under Format cells if, select "Greater than" as the option and type 300 into the box.
- Leave the Formatting style as the Default green background, and click Done.
इंटरैक्टिव व्यावहारिक अभ्यास
हमारे इंटरैक्टिव अभ्यासों में से किसी एक के साथ सिद्धांत को व्यवहार में बदलें
अभ्यास शुरू करें