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?
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?