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

What cells should be CFed, and what format?

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.

Add this code to the worksheet code module

Please Login or Register  to view this content.

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

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.

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

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.

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.

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.

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

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.

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.