iSixSigma

Excel Conditional Format

Six Sigma – iSixSigma Forums Old Forums General Excel Conditional Format

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #38213

    amir
    Participant

    Dear Sir
    Perhaps you can help me on this one:I am working on a worksheet of 120 columns by 300 raws.Nearly all cells contain conditional formats.Each conditional format contains 2 conditions using formulae referring to the adjacent cells (left or up).the conditions for the cells are:for a cell in an even raw and odd column     condition1: if cell value>[left] background=redcondition2: if cell value<[left] background=yellowfor a cell in an odd raw and odd columnif cell value>[up] background=redif cell value<[up] background=yellowfor a cell in an odd raw and even columnif cell value>[right] background=redif cell value<[right] background=yellow As you can see the entire spreadsheet consists of duplication of 4 basic cells:two cells in the first (even) raw (one of them is in the even column and the second in the odd column)two cells in the second (odd) raw (one of them is in the even column and the second in the odd column) I face difficulties to copy the cells containing the conditional formats either by copy&paste of the selected range or by copy&paste of the entire columns.The problem is:1. I get an error message indicating that the selected range is too large (even one cell)2, While saving the workbook I get a massage "Excel Could Not Save All the Data and Formatting" and when I open the saved file I realize that I lost the conditional formats in most of the cellsI checked the last-cell by Ctrl+End and get cell DP320 (which is correct)DO you have any idea how to sort this out?Amir Aharon
     
     

    0
    #114108

    Dennis
    Participant

    This may be oversimplifying your problem, but who knows, sometimes the simple solutions are best.
    Why not just use the format painter icon instead of copying and pasting your cells?  That’s really what it sounds like you want to copy – the formats, not the contents.  It’s the one that looks like a paintbrush.

    0
    #114116

    Brookiep
    Participant

    You could use the “Paste Special” function then you can then choose what it is you want to paste i.e the value or the format or the equation etc.

    0
    #114137

    amir
    Participant

    Hi Dennis
    Thank you for your response.
    My problem seems to be linked to the large dimensions containing conditional format.
    No matter if I copy and use paste-special for the formats or if I use the brush to cover small area at a time,  eventually, when I want to save my file I get the same error message warning that I may lose some of the formats. Then, when I open the saved file I realize that the warning was not in vain…
    Indeed many cells lose their conditional format definition, (and every time I try this from scratch I realize that the cells with the lost format are spread in other locations) 
    So I suspect this might link to memory allocation, but with 512 Meg I dont think my computer is too weak for that.
    What do you think?
    Would you like to see the file?
     
    Thanks, Amir

    0
    #114138

    amir
    Participant

    Hi Brookiep
    Thanks for your response. Also refer to the response of dennis.
    My problem seems to be linked to the large dimensions containing conditional format.
    No matter if I copy and use paste-special for the formats or if I use the brush to cover small area at a time,  eventually, when I want to save my file I get the same error message warning that I may lose some of the formats. Then, when I open the saved file I realize that the warning was not in vain…
    Indeed many cells lose their conditional format definition, (and every time I try this from scratch I realize that the cells with the lost format are spread in other locations) 
    So I suspect this might link to memory allocation, but with 512 Meg I dont think my computer is too weak for that.
    What do you think?
    Would you like to see the file?
     
    Thanks, Amir

    0
    #136270

    Gayrat
    Participant

    what can you say abuut main diffrent betwen excel 2000 and 2003

    0
Viewing 6 posts - 1 through 6 (of 6 total)

The forum ‘General’ is closed to new topics and replies.