Row Formatting

[MiAnPaDu]

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!

[#2]

@MiAnPaDu 

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.