+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting now working

  1. #1
    Registered User
    Join Date
    03-18-2008
    Posts
    9

    Conditional Formatting now working

    I'm trying figure out why this conditional formatting isn't working. In cell C5 I want the conditional formatting to take place. If any of the boxes in row 5 are clicked I want C5 to change background and text.

    I linked each checkbox to a cell to the right of the box. So if a box is clicked a cell will change from FALSE to TRUE. If any value it TRUE in row 5 cell P5 will turn to 1.
    If P5 is 1, I created a conditional format to go from a regular color to a greenbackground.

    Sometimes it works and other times it doesn't. I've messed with the formula in the condidtional format, I've tried using the "Stop If True" option but I cant get it to work on a constate basis. Can someone look at this and tell me what I'm missing?
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Conditional Formatting now working

    in P5 =--(SUM(--Q5:AB5)>0) as CSE

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,257

    Re: Conditional Formatting now working

    Rule should be

    =$P5=1

    I had to double click on Column C to enact CF: no idea why ?!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,944

    Re: Conditional Formatting now working

    I know you have gone to a lot of work putting those check boxes in, and it looks real nice, but why not just go for x's in the cells, instead?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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 not working
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2017, 04:42 PM
  2. [SOLVED] Conditional Formatting not working
    By tsummers46045 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-25-2017, 02:12 AM
  3. Conditional Formatting Not Working
    By Peaceful Jim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-21-2017, 11:33 AM
  4. Conditional formatting not working
    By mnhim001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2015, 02:26 PM
  5. Conditional Formatting not working.
    By EquityTrader in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2014, 12:50 PM
  6. Several Conditional Formatting only working on some
    By joblinger in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2009, 05:17 PM
  7. VBA conditional formatting not working
    By LarryC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-26-2008, 09:43 AM

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