How to add conditional Formatting rules to change cell colours on the basis of cell values when using Excel for Mac 2011. Excel for Office 365 for Mac Excel 2019 for Mac Excel 2016 for Mac More. Conditional formatting quickly highlights important information in a spreadsheet. But sometimes the built-in formatting rules don’t go quite far enough. Adding your own formula to a conditional formatting rule.

Not specific to the watch app, but does anyone know if Overcast has a setting to start the podcast at a certain time/point in the podcast. I had an app that I could always start at a certain point and that was great.

Marco Arment's popular podcast client for iPhone and iPad, received a major update today to version 5. While I've long praised Apple's work on their built-in Podcasts app for iOS – particularly since and leveraging Podcasts' support for AirPlay 2 – I also recognize the appeal of Overcast's advanced features and powerful audio effects. Sprinkled throughout Overcast's release history are design details and enhancements and that make it a sophisticated, versatile client for podcast aficionados who don't want to settle for a stock app. From this standpoint, despite welcome improvements to Podcasts in iOS 12, changes in Overcast 5 make it an even more attractive option that has caused me second-guess my decision to embrace Apple's native app. Voice app for computer. Redesigned Now Playing The most notable difference between the old Overcast and the updated version is the redesigned Now Playing screen.

Page indicators and hidden gestures to navigate show notes and chapters are gone, replaced by a carousel of swipable cards containing effects, podcast artwork, show notes, and chapters (if available). The new pages in Overcast 5's Now Playing screen. Overcast's new Now Playing screen design is interesting and, I believe, successful for a variety of reasons. From a mere interaction perspective, it fixes one of my longtime gripes about Overcast – the hidden nature of audio effects and show notes, whose existence was only communicated visually with three small 'page dots' that were easy to miss (and if an episode had chapters, the page dots would be hidden altogether). By comparison, Overcast 5's cards are boringly obvious: they flank podcast artwork, which isn't edge-to-edge anymore to hint at the presence of multiple pages. Furthermore, using the redesigned Now Playing screen simply feels nice in practice.

When you tap on the minimized player to reveal Now Playing in full-screen, you feel a subtle tap on your iPhone. This is part of a series of haptics that Arment added throughout Overcast to reinforce key interactions with the app. For instance, playback controls generate a thud with the same intensity of opening/closing the Now Playing screen, but you'll feel slightly lighter taps when swiping across pages.

When used judiciously, haptics can add a new dimension to apps' UIs, and I think Overcast 5 is a great new example of a third-party app leveraging the Taptic Engine in a meaningful way. There's also an argument to be made for this Now Playing design enabling a more comfortable interaction with Overcast predicated upon the idea of. Now in addition to pulling the Now Playing screen up and down with the flick of your thumb, you can also swipe horizontally anywhere on the screen to navigate between cards. The empty areas around playback controls make for good swiping spots in Overcast 5; even if you're planning on getting one of Apple's, rest assured the new Overcast won't force you to reach pages at the top of the screen to move between them. Even though I don't use it often, I should also mention the updated Overcast app for iPad, which now uses a split-screen layout for playlists/episode lists and the Now Playing screen. Overcast 5 uses a new split-screen layout on iPad.

When Overcast is running in a regular size class on iPad, it'll display the main and Now Playing views simultaneously. This is a nice way to take advantage of the device's larger display, and it makes it easier to multitask inside Overcast without having to constantly dismiss the player. I wish more entertainment apps on iPad offered a similar approach to watch media and continue browsing lists of episodes. As someone who actually Apple's attempt at splitting Control Center into multiple widgets, I'm a fan of Overcast's redesigned Now Playing screen.

I'm always in favor of surfacing functionality to users in an obvious way without hiding key features behind undiscoverable pages or swipe gestures. Overcast 5's Now Playing redesign succeeds in making interactions more intuitive and pleasant, improving one of the app's most recognizable screens without alienating existing users.

Media Shortcuts The main reason I've been enjoying using Overcast again for the past several weeks is its excellent support for Siri shortcuts in iOS 12. Overcast 5 comes with the best implementation of I've tested to date, with only one caveat upon which hangs my indecision between Arment's app and Apple's Podcasts. Thanks to media shortcuts in iOS 12, you can now start playback in Overcast in the background (i.e.

Without launching the app) from Siri, the Search screen, or the new Shortcuts app. As I explained in, media shortcuts don't qualify as full-on support for third-party audio sources in Siri; you can't just install Overcast 5 and say 'Hey Siri, resume playback in Overcast', as you would with Apple Music or Podcasts. You have to configure a shortcut from inside the Overcast app first, give it a custom Siri phrase, then trigger it from Siri. Overcast 5 is one of the many apps that has adopted a dedicated Siri Shortcuts section in its built-in preferences to expose all the shortcuts users can configure. These shortcuts are organized in three categories (controls, playlists, and podcasts) but they can be fundamentally described as two types of commands: you can either toggle an Overcast-specific feature as a shortcut (such as turning Smart Speed on, recommending an episode, or skipping chapters) or start playback of the most recently played or first unplayed item in a list of episodes. You can trigger Overcast features with Siri shortcuts as well. From Overcast's settings, you can tap on any of the available shortcuts to add it to Siri with a personalized phrase; otherwise, you'll be able to find Overcast's donated and recently used shortcuts in the main Settings app, as suggestions or results in Search, and in the Shortcuts app under the 'Overcast' section.