+ Reply to Thread
Results 1 to 3 of 3

Is it possible to add conditional formatting based on a check box condition?

  1. #1
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    Is it possible to add conditional formatting based on a check box condition?

    I would like to change the color of a cell to either green, yellow, or red based on a few conditions. One of the conditions would be based on whether a check box was checked or not.
    Thanks,
    redsab
    Last edited by redsab; 08-23-2014 at 07:42 AM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Is it possible to add conditional formatting based on a check box condition?

    The checkbox will/can be linked to cell, so you can use that cell value in the conditional formatting.

  3. #3
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    Re: Is it possible to add conditional formatting based on a check box condition?

    Thanks BadlySpelledBuoy, that worked great!!
    redsab

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting on certain condition
    By lordcraptor in forum Excel General
    Replies: 2
    Last Post: 01-06-2014, 08:56 PM
  2. [SOLVED] Conditional Formatting for 2 condition
    By MyOnion in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-18-2013, 03:29 AM
  3. [SOLVED] Conditional formatting based on a text and a numeric condition
    By coolshooter in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2012, 02:56 AM
  4. 3 Condition Conditional Formatting
    By aikidokid in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-12-2007, 07:21 PM
  5. 4 condition conditional formatting
    By jeffg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-05-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1