excel突出显示列匹配文本的行

以下示例是关于Excel中包含excel突出显示列匹配文本的行用法的示例代码,想了解excel突出显示列匹配文本的行的具体用法?excel突出显示列匹配文本的行怎么用?excel突出显示列匹配文本的行使用的例子?那么可以参考以下相关示例代码来学习它的具体使用方法。

[英]:excel highlight rows where column matches text源码类型:Excel
# Short answer:
"Apply to range" determines which rows will be highlighted
"Rule Type" should be Formula
"Format all values where this formula is true" should have syntax like:
	=$first_cell_to_check="text_to_match" e.g.: =$C2="No"
# Note, it's important that the first_cell_to_check is preceeded by a $. That
#	"locks in" that column causing the conditional formatting to be applied to
#	each row, rather than just the e.g. C2 row
# Note, when applying conditional formatting to a multi-cell range at once,
# 	you need to write the formula as it pertains to the very first cell in
#	that range

本文地址:https://www.itbaoku.cn/snippets/787532.html