CODEWITHSUNDEEP
if-statementgoogle-sheetsgs-conditional-formatting
VikingScript
VikingScript

Reputation: 109

Highlight all cells in a row that are not blank based on value in one cell within row

Trying to highlight only cells within the row that are not blank if "shipper printed" is selected in column "M".

So far my unsuccessful conditional formatting:

=AND(NOT(ISBLANK(A:N),$M:$M="SHIPPER PRINTED"))

Upvotes: 2

Views: 205

Answers (1)

pnuts
pnuts

Reputation: 59442

Please select ColumnsA:N and try the formula rule:

=AND(NOT(ISBLANK(A1)),$M1="SHIPPER PRINTED")

CF handles the ranges for itself, based on your selection, but you do need to bring the final parenthesis forward, to 'close' the NOT sooner.

Upvotes: 2

Related Questions