+ Reply to Thread
Results 1 to 13 of 13

Conditional formatting problems

  1. #1
    Registered User
    Join Date
    05-20-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Conditional formatting problems

    I am trying to apply conditional formatting to various cells, but the behavior is inconsistent. Essentially, I want a cell to display when a checkbox is checked, and to not display when it is not. Thus, I simply used a condition to apply white formatting when the box is not checked. The weird part is that it works some of the time, but not consistently. I must be missing something. Please see cell J10 on the attached spreadsheet.
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Conditional formatting problems

    What cells should be CFed, and what format?

  3. #3
    Registered User
    Join Date
    05-20-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Conditional formatting problems

    J10. The condition is if J77 is TRUE, then to use a blue font, but if it is FALSE, then to use a white font. Essentially, I am trying to make the cell not display if J77 is TRUE.

  4. #4
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Conditional formatting problems

    Add this code to the worksheet code module

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-20-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Conditional formatting problems

    Thank you. If you have a moment, would be helpful to understand why this is necessary.
    Much appreciated!

  6. #6
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Conditional formatting problems

    Because the checkbox is not triggering the CF, so we are using the calculate event to pick up the change in J77, and then using the screenupdate to force CF to react.

  7. #7
    Registered User
    Join Date
    05-20-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Conditional formatting problems

    I see. Thanks again. Very helpful (and time saving!)

  8. #8
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Conditional formatting problems

    Just found that you have cross-posted at ExcelGuru, http://www.excelguru.ca/forums/showt...tting-problems.

    If you must cross-post, please have the decency to inform us of such so that those of us that do not wish to waste our time can ignore you.

  9. #9
    Registered User
    Join Date
    05-20-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Conditional formatting problems

    I thought they were completely different forums (kind of a reasonable assumption given the different names). Was it really necessary to react that way? Took you more time to respond then to "ignore" me.

  10. #10
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Conditional formatting problems

    Of course they are different forums, that is irrelevant. If you post of multiple forums, there could be someone working on a solution in one whilst someone at another has already solved the problem. There might also be further information divulged at one site which is not available at the other. So you, by your action, could be wasting the time of people who are giving their time and knowledge freely. If I had known that you were cross-posting, I for one would not bother responding, even if you were polite enough to inform that you were.

    If I had chosen to ignore you, you carry on in this manner regardless. By pointing it out, who knows, you might modify your behaviour.

  11. #11
    Registered User
    Join Date
    05-20-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Conditional formatting problems

    1) I understand your point, just wish you had delivered the message in a kinder way. Some of us are not familiar with the expected etiquette of these forums.
    2) I don't want to waste anyone's time. My only motivation is to get quick and good answers. Often posts are not responded to, and/or the answers are not adequate. If you have any suggestions on alternative methods of increasing chances for quick and good answers, I am all ears.

    All the best,
    David

  12. #12
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Conditional formatting problems

    David,

    However you read it, it was not meant as kind, nor was it meant as unkind. It was a statement of fact as I see things, you did something that is bad form, and so I pointed it out too you in the hope that you do it differently in future.

    You say that ... My only motivation is to get quick and good answers. So it would seem, and that may be what leads you to cross-post. As I said, cross-posting per se is not the problem, it is not informing anyone that you have. If you cross-post and you provide links to those cross-posts, people can then make their own minds as to whether they join in. Again as I said, I would rather ignore cross-posted threads altogether, my time is valuable to me and I have no desire to waste it, but others may react differently. To not assume that all responders at all forums are at your beck and call, that is not just good forum etiqutte in my view, that is basic good manners.

    You got a good answer, I would venture a great answer (but then I would say that ), so you should be happy, regardless of my other statements.

  13. #13
    Registered User
    Join Date
    05-20-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Conditional formatting problems

    In fact, I am and lesson learned. Thank you.
    Incidentally, when is it necessary to force the recalculations and screen updates? I thought if calcs were set to automatically recalculate under Options, then forcing a recalc wouldn't be necessary. I am asking since my experience with this spreadsheet is making me concerned about problems I might not have noticed on other spreadsheets I have created.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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