Using Microsoft Excel’s sorting feature , you can sort your cells that are either manually colored or conditionally colored by their color. This works for multiple colors and we’ll show you how to implement it in your spreadsheets. With your spreadsheet open, in the ribbon click Data > Sort. In the “Sort By” dropdown menu select the column you want the data sorted by. From the “Sort On” list, select “Cell Color,” then choose a color and location for sorting. Add as many levels as needed, then click “OK.” With the feature, you can place the cells containing a specific color at the top or the bottom of the list. For example, you can place all your green-colored cells at the top while keeping all the red ones at the bottom. You can sort by a cell’s background color as well as the font color, as we’ll explain below. RELATED: How to Sort and Filter Data in Excel Sort Data by Cell Color or Font Color in Excel To start sorting , open your spreadsheet … [Read more...] about How to Sort by Color in Microsoft Excel
Lenovo yoga tab 3
Dizo, the brand under Realme TechLife ecosystem, has expanded its smartwatch lineup with the launch of Realme TechLife Watch SZ100 . The smartwatch is capable of monitoring body temperature and it comes equipped with SpO2 and heart rate monitor. Price and availability The Realme TechLife Watch SZ100 comes with a price tag of Rs 2,499 and it comes in Lake Blue and Magic Grey colour options. The smartwatch can be purchased online from Realme.com and Amazon India website. The device will also be available on offline stores starting May 22. Realme TechLife Watch SZ100 smartwatch Realme TechLife Watch SZ100 sports a 1.69-inch colour touchscreen display with 240x280 pixel resolution. The device comes with 110+ watch faces and it comes equipped with a heart rate sensor and SpO2 monitor. Realme TechLife Watch SZ100 comes with Bluetooth 5.1 support and is compatible with Android and iOS operating systems. The device can be used with the Realme Fit companion app. … [Read more...] about Realme TechLife Watch SZ100 with up to 12 days of battery backup launched, priced at Rs 2,499
Wondering where all your iPhone (or iPad ) free space has gone? If you use Apple’s Podcasts app and have active subscriptions, it’s possible that your device has been downloading and holding onto episodes. Here’s how to check, and how to make sure it doesn’t happen in the future. Clear Out Your Old Podcasts If you visit Settings > General > Storage on your iPhone or iPad, you’ll see a breakdown of how your device is using available space . This includes categories like Apps, Photos, and Media. The system doesn’t distinguish between podcasts or offline music , it uses the same “Media” label for both. You can scroll down the list on this page to see which apps are using up your free space, including the Podcasts app. Tap on it and at the bottom of the page, you’ll see which shows have been downloaded and how much space they are consuming. You can clear them out by tapping the “Edit” button and then tapping the red circle followed by “Delete” next to a show. … [Read more...] about Are Podcasts Hogging All Your iPhone Free Space?