Help! Has anyone heard of glitches with conditional formatting in Excel XP
SP3? I teach courses and am considered an advanced user, however, I have
never seen conditional formatting NOT work. A user pointed out a situation
whereby the conditional formatting works in 2 sheets of a workbook, but not
on some of the other sheets with the exact same scenario (different data, but
formatted identically). Basically, the user is looking to have the sum
result match another cell and turn the number red if it does NOT match. Our
situation is this - the first 2 sheets work perfectly (number matches Sum -
no color change), the next couple of sheets (number matches Sum - but changes
to red color anyway!!) ? Why?! Checked conditions, formatting, restarted...
The info on each sheet all comes from Cognos and though the specific data is
different, everything else is the same!! What else can be wrong? There
doesn't appear to be a logical explanation for the failure!