Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting Question (2003)

    I need to preserve some historical data that has conditional formatting applied to it. Going forward with this spreadsheet, I will be changing the "trigger" for the conditional formatting but I don't want to lose the formatting of the historical data that had the old trigger. My conditional formatting, if the conditions are met, will turn the cell data either green or red but the cell value that determines this is changing as of next week. How can I keep all the old data intact?

    Thank you.

    Deb

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Formatting Question (2003)


  3. #3
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting Question (2003)

    Thanks for pointing me to that Steve. I'll need to play with it a bit as I got a "type mismatch" upon running it. I may be back here again with further questions!

  4. #4
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting Question (2003)

    I've just read about a method for doing this that is quite simple and doesn't involve a macro. I copied my data and pasted it into Word; I then copied the data from Word and put it back into Excel...conditional formatting is now gone and the font colours have remained!

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formatting Question (2003)

    That's a great solution if you only have cells filled with constants, or simple formulas. If you have more complicated formulas, they will be lost in the transition to Word.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •