Conditional Formatting No Longer Working

M

Mitzi B.

I created a spreadsheet with conditional formatting in the 97-2003 version...
I've recently updated to 2007 Office and not sure if that has anything to do
with it, but, when I create new conditional formatting on that same file, I
have to 'step off' the spreadsheet for the condition to work. i.e. if
$C$29="Yes" turn B7 Red Bold Font... so, I change C29 to Yes... but, B7
doesn't change unless I actuall go off of Excel (not close it) and come
back... I can see that B7 is 'trying' to change, but, not entirely. I've
tried saving the document as a .xsls version... or re-saving as a 97-2003
version and can't get it to work. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top