Colour a cell based on the colour of another cell

bomalley

New Member
Joined
Feb 16, 2002
Messages
21
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 <U>colour</U> of another cell?
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top