Выделите строку Excel на основе значения столбца

Примеры кода

1
0

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

Похожие страницы

Похожие страницы с примерами

На других языках

Эта страница на других языках

English
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
中文
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................
Балгарскі
..................................................................................................................
Íslensk
..................................................................................................................