|
Answer» I'm working with window 7, 64 bit PC, MS excel2010.
my sheet has multiple cells with conditional formatting. some cells react immediately on input changes. others only show a small band at the edge of the cell with the NEW format. when i enter the cell for editing, and leave the cell without changing anything, the cell will react to the new format. also if i copy sheet to another workbook, all cells react immediately to the conditional formatting. can SOMEONE tell me what COULD be wrongHas this always been a problem with your MS Excel formatting or did it just start?
Might try looking for something here.
http://www.excelforum.com/excel-2007-help/774185-conditional-formatting-cells-that-contain-formulas-not-working-as-intended.htmlits is an excel97-2003 file that worked fine on my old windows XP pc. but on my new windows7 with excel2010 in the compatibility mode, the problem showed up.
thanks for the advice, i will LOOK into it
|
