Hi Everyone,
I am comparing two tables from different sources which in theory should be the same. I'd like to be able to see the difference and if difference what is in each table to solve the difference.
I have the done the below formula which works well:
=IF('PG22-26'!E12='ELT File PG22-26'!E12,"",'PG22-26'!E12&"&"&'ELT File PG22-26'!E12)
However, everything is in black and difficult to read. Does anyone know if I could write what is in the first table in red (cf. in red above) and what is in the second table in green (cf. in green above).
Thanks,
Maxime
Bookmarks