Vba change row color based on text

Hello,
I need to change the font color of the entire row for any cells containing the word BATTERY in a column with named range TEXT1. I have tried conditional formatting, but it only changes the font to green within that column, not the entire row.

Currently I am also using the code below within this report to change any rows with "000" to red.

Please Login or Register  to view this content.

I tried using the same code for the green rows, but nothing happens. Sample of code below:

Please Login or Register  to view this content.

Can anyone suggest what am doing wrong?

Question: Are both codes in the same sheet, workbook? if so try changing the Sub call of the 2nd one to something different. Ex( 1st code Sub call is Incomplt_Calls) (2nd code Sub call try Incomplt_Call)

Ooops! No, the first is Incomplt_Calls (red) and the second is Battery_Calls.

OK, so I've tried conditional formatting with a few different formulas and none of them work. I do import the data as text, but don't know if that would have anything to do with the problem.

I used the following steps and formulas listed below.

• Conditional Formatting
• New Rule
• Use a Formula to determine which cells to format
• Enter Formulas
• Format font
• OK
• "Manage Rules"
• In the "Applies to" box =$A$1:$AN$783

Formulas tried:

• =INDIRECT("o"&ROW())="*BATTERY*"
• =IF($O$2="*BATTERY*", TRUE, FALSE)
• =$O:$O="*BATTERY*"

That works perfect!!! I could not find anything on the web telling me to utilize a formula like that.

Man I wish I could give you some cookies or something. You are always so helpful. I truly appreciate all of your help.

Thank you!!!