The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers
«
»

Excel 2011/2010: Conditional formatting of TRUE / FALSE values in an Excel range

Posted by jpluimers on 2024/02/13

The conditional formatting feature in Excel is so cool!

If you use FALSE and TRUE expressions to check validity, you can easily make these red and green.

[Wayback/Archive] Conditional formatting of TRUE / FALSE values in an Excel 2010 range – Super User (thanks [Wayback/Archive] tbone for asking and [Wayback/Archive] digitxp for answering):

  1. Select your cells.
  2. Home Tab -> Format Group -> Conditional Formatting -> New Style:

    True Values

  3. Repeat step 2 with this:

    False Values

The above is for Excel 2011 on MacOS, but Windows is really similar.

Via: [Wayback/Archive] excel red when false – Google Search

–jeroen

This entry was posted on 2024/02/13 at 12:00 and is filed under Apple, Excel, Mac, Mac OS X / OS X / MacOS, Office, Office 2010, Office 2011 for Mac, Power User, Windows. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

«
»