This worked great for me with cells that were already formatted to have the strikethrough, but any new cells I designate with a strikethrough (via conditional formatting) will not update the sum total. Any thoughts?
This worked great for me with cells that were already formatted to have the strikethrough, but any new cells I designate with a strikethrough (via conditional formatting) will not update the sum total. Any thoughts?
Last edited by JBeaucaire; 03-14-2013 at 12:53 PM. Reason: Moved to a thread of it's own, as per forum rules.
tdootster, Welcome to the Forum.
Unfortunately your post did not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
===============
I've moved your question to a thread of its own, as per forum rules. Please take a moment to read them. (link above and in the menu bar)
===============
Your question:
Cells that are ACTUALLY formatted with a strikethrough will work.
Cells that are conditionally formatted with a strikethrough will not work. They aren't ACTUALLY formatted that way, so the function cannot see the display adjustment the conditional formatting is applying to the DISPLAY.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks