I have a workbook created in previous version of Excel. I have numerous
conditional formating in the spreadsheet that change all the cells in a row
when a particular cell in that row contains specific information. Now only
the single cell I enter the information into changes formatting (not the
entire row that should change) until I scroll away from that section of the
spreadsheet. Then when I return the cells are changed. I am guessing this is
something in Excel setup but i can't find it. Thanks for the help.