Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting of cell
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting of cell
I have this problem occasionaly. The problem is that my video card isn't
fast enough. Here's some advice from Dave Peterson in an old post: "Dave Peterson" There's an acceleration setting under: control panel|Display|Settings Tab|Advanced button|troubleshoot tab Maybe you could try a few adjustments. "T. Valko" wrote: I have a similar problem but in reverse order. The problem is my video card isn't up to the task! Sometimes when I apply formatting it doesn't display properly. When I scroll out of that area and then scroll back the formatting displays properly. It has something to do with the refresh rate of the video. Specing out the video wasn't a big priority when I bought this machine. Now I know better. Biff I haven't had this problem lately so I haven't had a reason to try Dave's suggestion. -- Biff Microsoft Excel MVP "AJK" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting of cell
I have a pretty fast machine with good video card. This didn't happen with
older version of Excel or any of my graphic programs. Maybe its due to the new Office 2007 being such a big program. I'll experiment with the video display settings and see if that helps. "T. Valko" wrote: I have this problem occasionaly. The problem is that my video card isn't fast enough. Here's some advice from Dave Peterson in an old post: "Dave Peterson" There's an acceleration setting under: control panel|Display|Settings Tab|Advanced button|troubleshoot tab Maybe you could try a few adjustments. "T. Valko" wrote: I have a similar problem but in reverse order. The problem is my video card isn't up to the task! Sometimes when I apply formatting it doesn't display properly. When I scroll out of that area and then scroll back the formatting displays properly. It has something to do with the refresh rate of the video. Specing out the video wasn't a big priority when I bought this machine. Now I know better. Biff I haven't had this problem lately so I haven't had a reason to try Dave's suggestion. -- Biff Microsoft Excel MVP "AJK" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting one cell based on content of another cell | Excel Discussion (Misc queries) | |||
Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) |