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

@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.