Conditional Formatting - duplication icons across another range

**Tacalabala** · 03-03-2018, 07:16 PM

Hello all again

This is a brilliant forum, thank you so much!

I think the title sums it up really - I would like the CF icons found in the the two rating columns (E) in RATING to be shown on the cells in SCHEDULE which match the value in column A in RATING, for example all 'STABAEK' cells would show 5 bars, while all 'stabaek' cells would show 2 bars (upper = home, lower = away).

**FDibbins** · 03-04-2018, 03:15 AM

Icon sets can only be applied to teh cell they reside in, they cannot "point" to other cells. Perhaps use a helper column to reference teh data you need to replicate, and then ise ICON sets on that, instead?

**Tacalabala** · 03-04-2018, 03:59 AM

I feared that may be the only solution. Ok, thank you ☺

**AliGW** · 03-04-2018, 04:03 AM

Ford is right - the cells themselves must contain the values, however you can use a cell reference (e.g. =E3) and you can also set the value not to appear in the cell with the icon, so your helper columns on the Schedule tab could be quite narrow.