mg_ffg
Level 1 (1 points)

Q: Conditional Formatting Rules Not Working

I have OSX 10.10.5 and Numbers 3.6.1.

 

I have been working with spreadsheets that use conditional formatting rules to apply a colored fill to cells. True values are filled green and False values are filled red. Recently, Numbers stopped applying the fill to the cells in one of these spreadsheets. I tried recreating the rules and creating rules with variant shades, but Numbers is not processing these rules.

 

Does anyone know a fix, or am I doing something wrong? Here's a screenshot of the rules.

 

Screen Shot 2016-03-01 at 12.15.53 PM.png

iMac, OS X Yosemite (10.10.5)

Posted on Mar 1, 2016 10:18 AM

Close
mg_ffg

Q: Conditional Formatting Rules Not Working

  • All replies
  • Helpful answers

  • by MickCharles,

    MickCharles MickCharles Sep 5, 2016 4:23 PM in response to mg_ffg
    Level 1 (4 points)
    iWork
    Sep 5, 2016 4:23 PM in response to mg_ffg

    I have just experienced the exact same situation.  Very simple Condition instead of True/False with Green/Red I am using Credit/Debit filling cell Green/Red and Bold text.  I see no replies to this inquiry...the sheet was working perfectly and suddenly when i made a simple change from Credit to Debit there is no fill or text format applied event though the Conditional Highlighting is correctly sent (as your example illustrates).

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 5, 2016 4:38 PM in response to mg_ffg
    Level 6 (18,960 points)
    iWork
    Sep 5, 2016 4:38 PM in response to mg_ffg

    Perhaps sharing the problem document will help us help you.  I can not replicate the problem by just setting up cells with conditional formatting based on the "TRUE" and "FALSE"

  • by t quinn,

    t quinn t quinn Sep 5, 2016 6:47 PM in response to mg_ffg
    Level 5 (4,930 points)
    Mac OS X
    Sep 5, 2016 6:47 PM in response to mg_ffg

    Hi mg_ffg,

     

    Your rules look good. What do the cells look like could there be invisible characters or spaces?

     

    quinn

  • by MickCharles,

    MickCharles MickCharles Sep 6, 2016 3:09 PM in response to mg_ffg
    Level 1 (4 points)
    iWork
    Sep 6, 2016 3:09 PM in response to mg_ffg

    I've tried to eliminate the potential of extraneous characters by changing the Conditional Highlight criteria from "Text Is" to "Text Contains"...generalizing the criteria in an attempt to eliminate the idea that there may be unseen characters...yet still the Conditional Highlight does is not working - as it has for 9+ months.

  • by t quinn,

    t quinn t quinn Sep 6, 2016 6:11 PM in response to MickCharles
    Level 5 (4,930 points)
    Mac OS X
    Sep 6, 2016 6:11 PM in response to MickCharles

    Hi Mick,

     

    You could try trashing the rules altogether and then redoing them after a save and quit. It may come down to sharing the actual document or cuttinga nd pasting tables to a new one. With the limited info we have and being unable to duplicate the issue there is not much advice we can give.

     

    quinn

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 6, 2016 6:14 PM in response to MickCharles
    Level 6 (18,960 points)
    iWork
    Sep 6, 2016 6:14 PM in response to MickCharles

    test conditional formatting on a NEW document and see if it works.  It may be that your document is corrupt