Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Colour a cell based on the colour of another cell

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi there people,

    For work, I run a weekly performance report. There are summary worksheets and detail worksheets in this report. The detail worksheets are conditionally formatted based on the values, however the summary sheets (which simply show performance as red, orange or green), I can't conditionally format from the data, as they are based on a range of data. Is there any way to format a cell based on the colour of another cell?

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes there is a way but not based on conditional formatting itself, but rather on the "why" of conditional formatting. Excel does not recognize a conditionally shaded cell to be the true interior color index, because that index is subject to change per a future condition.

    What you can do is insert a worksheet level change event on the Summary sheet to shade its cells a given color, depending on (I presume) the values in those cells. A Select Case structure would probably work out well in that case, as it is not limited to just 3 conditions, which a standard conditional format imposes.

    Tom Urtis

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for that Tom. The problem is however that the cells in the Summary Sheet don't contain values, well they do, but they are titles for the data. Eg. "Activations Completed". This cell then hyperlinks to the data on the sheet.

    _________________
    Cheers,
    Brandon

    [ This Message was edited by: bomalley on 2002-02-20 19:03 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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