Excel 2007 : Help with formating cells off another cells Conditional Formatting>Color Scales

[MacroMartin]

Hello to you & thank you for your time.

First, I’d like to send a sincere heartfelt THANKYOU to members Leith Ross and To royUK for all the help they have offered in getting my membership on the forums activated.

I am currently working on a EXCEL OFFICE 2007 workbook that is very Data and Macro extensive.

On one worksheet I am summarizing some data in cells B60:S79.
All cells are using “Absolute Referencing” to cells in other worksheets.
Cells B60:B79 are names. All other columns in this range are numerical.

This data is being sorted (through Macro buttons) by Column Header in C59 ( Largest to Smallest ) then by Q59 ( Largest to Smallest ) then by B59. ( “Names” A to Z )

Cells C60:79 are using Conditional Formatting > Color Scales. Cells Q60:Q79 use Conditional Formatting > Icon Sets.

So as the data changes in cells C60:79 The Conditional Formatting > Color Scales changes the cells fill colors respectfully.

What I am trying to do, or need to have happen is to have the rest of the cells in that ROW automatically use the same FILL color. So as to more easily track the statistics by name (B60:79) across each row as the data is sorted and updated.

So if cell C62 changes to cell fill color #FFCC22 then cells B62, D62, E62, F62, G62, H62, I62, J62, K62, L62, M62, N62, O62, P62, Q62, R62, S62 all change to cell fill color #FFCC22 respectfully as C62.

Is this possible? I can’t seem to figure this one out.

Thank you for your time,

-Martin

[starryknight64]

I'm assuming the cell that first changes color is because of conditional formatting?

If so, then try copying that cell and doing a paste special over your entire table data only pasting the formatting.

I hope that helps!

[MacroMartin]

Thank you for the reply. That doesn't appear to work. Copying the cell format from a conditional format>color scales to the
other cells through a paste special just makes every other cell have conditional format>color scales so I end up with an entire rainbow of colors...LOL...

[MacroMartin]

any suggestions?

[tigertiger]

plz, post your sample file to help other easier understand,
.