Conditional Formatting using cell 'address' column

[Mrgoodkat]

Hi all,

I currently have a large data range which I will simplify as A1:F6 as shown below.

In the G column I have a list of cell addresses calculated from numerous previous formulas referring to specific cells in the aforementioned data range within the same row.

I am looking for a way to use conditional formatting to simply outline the cell addresses listed in the G column.

I cannot simply write out each cell address in the 'Applies to' section of conditional formatting as this spreadsheet will serve as a template and needs to automatically highlight the cells in the G column. In addition to this there is such a large list that to simply write each one out would be a large waste of time.

I have tried to concatenate all the cells in the G column and then use this in the 'Applies to', however this simply lists the very first cell in the G column (E1 in the below example).

It is also worth noting that I cannot do multiple conditional formats as this will result in over 300 separate instances and as a template I am trying to keep the spreadsheet as sharp as possible

So, any ideas?

A1	B1	C1	D1	E1	F1	Cell Addresses
A2						$E$1
A3						$B$2
A4						$F$4
A5						$A$5
A6						$C$6

<tbody>
</tbody>

 

[Special-K99]

Select top left corner cell

Conditional Formatting
New Rule
Use a formula to determine...

=NOT(ISNA(MATCH(ADDRESS(ROW(),COLUMN()),G$1:G$6,0)))
format as required

Use Format painter to copy to other cells

 

[Mrgoodkat]

Thank you very much, this works a charm.

This is a pretty great community!