Row Formatting

New Contributor

Hello! I would like assistance with the following issue:


I need to change the color of a row if it does not contain a specific word/phrase.


For example: If the row does not include "Payment by Debit" or "Payment by Credit."


Thank you!

1 Reply


Let's say you want to apply this to rows 2 to 100.

Select these rows. The active cell in the selection should be in row 2.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format.

Enter the formula


=ISERROR(MATCH("Payment by Debit", 2:2, 0))


Click Format...

Activate the Fill tab.

Select a highlight color.

Click OK, then click OK again.


If you wish, repeat these steps, but with the formula


=ISERROR(MATCH("Payment by Credit", 2:2, 0))


and another fill color.