Custom Formula Conditional Formatting incorporating 2 spreadsheets

Question

Is it possible to arrange a conditional formatting custom formula based on information input into a different spreadsheet?

For example, I have 1 in A1, 2 in A2 and 3 in A3 on a spreadsheet saved as 'Numbers' and in a worksheet titled 'List' and in a spreadsheet saved as 'Input' I enter 1 in A1 of a worksheet titled 'Entry'. When I enter 1 in the 'Input' spreadsheet I would want cell A1 in the 'Numbers' spreadsheet to become highlighted.

I've had a play around with IMPORTRANGE AND IF formulae but to no avail

player0 player0 · Accepted Answer · 2019-12-09T23:03:56

try:

=A1=IMPORTRANGE("16nnuzNRx_kGGJm1EBVX7kBT2bfW1-2TYwSiuaLF-Q", "Numbers!A1:A")

that weird number is spreadsheet ID (you can find it in URL between d/ and /edit)

note that both ranges need to be formatted same

a faster alternative would be to use IMORTRANGE to import those values in some column and then just compare those two columns

Custom Formula Conditional Formatting incorporating 2 spreadsheets

1 Answers