Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    128
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Basic Shape & Conditional formating (2003)

    Lounger's

    I have a number of basis shapes containing cell references to cell with conditional formatting - I can get the reference cell value but not the conditional formatting

    Is there some way to apply the conditional formatting of a cell to the basic shape referencing it?

    I hope this make sense

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

    Re: Basic Shape & Conditional formating (2003)

    Conditional formatting applies only to cells, not to shapes.
    You could write code in the Worksheet_Change event or Worksheet_Calculate event (depending on how the value of the cell gets changed) to format the shapes.
    Or you could copy the cell to the clipboard, then hold down the Shift key while clicking on the Edit menu. It'll have an option Paste Picture Link. This will result in a resizable rectangle that shows both the value and the formatting of the cell. You can also use the Camera tool for this (the Camera tool is a toolbar button available in the Tools category when you customize your toolbars)

  3. #3
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    128
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Basic Shape & Conditional formating (2003)

    Hans,

    Thanks for the quick response - again.

    Will give your suggestion a go

  4. #4
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: Basic Shape & Conditional formating (2003)

    Hans,

    Tried your suggestion which works fine as long as the cell does not recalculate.

    I've attached a sample of what I'm trying to achieve if you or any other Longers have any suggestions

    Regards

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

    Re: Basic Shape & Conditional formating (2003)

    I would create the summary using ordinary cells with formulas. You can then apply conditional formatting.
    The Camera tool option will work too, but it may not look exactly the way you want - see attached version.

  6. #6
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: Basic Shape & Conditional formating (2003)

    Thanks for your help - again

    Regards

Posting Permissions

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