自定义公式条件格式,包含2个电子表格 [英] Custom Formula Conditional Formatting incorporating 2 spreadsheets
问题描述
是否可以根据输入到其他电子表格中的信息来安排条件格式的自定义公式?
Is it possible to arrange a conditional formatting custom formula based on information input into a different spreadsheet?
例如,在保存为数字"的电子表格中,在名为列表"的工作表中,在保存为输入"的电子表格中,我在A1中有1,在A2中是2,在A3中有3,在保存为输入"的电子表格中,我在A1中输入1名为条目"的工作表.当我在输入"电子表格中输入1时,我希望数字"电子表格中的单元格A1突出显示.
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.
我玩过IMPORTRANGE和IF公式,但无济于事
I've had a play around with IMPORTRANGE AND IF formulae but to no avail
推荐答案
尝试:
=A1=IMPORTRANGE("16nnuzNRx_kGGJm1EBVX7kBT2bfW1-2TYwSiuaLF-Q", "Numbers!A1:A")
这个奇怪的数字是电子表格ID(您可以在d/
和/edit
之间的URL中找到它)
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
一种更快的替代方法是使用IMORTRANGE
将这些值导入某个列中,然后仅比较这两个列
a faster alternative would be to use IMORTRANGE
to import those values in some column and then just compare those two columns
这篇关于自定义公式条件格式,包含2个电子表格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!