Vba change row color based on text

[DoodlesMama]

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?

[moonsaga]

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)

[FDibbins]

Conditional Formatting will do this for you. You have to use "use formula" to make it apply to cells other than where the criteria is

[xlbiznes]

Hi,

changes made to your code to give the desired result :

Please Login or Register  to view this content.

[DoodlesMama]

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

[DoodlesMama]

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*"

[FDibbins]

without seeing any data...
=search("Battery",$O$2,1)

When using a formula in CF, you just need the bare bones. It works on TRUE/FALSE, so if the search finds something = TRUE, if not, = error= FALSE

[DoodlesMama]

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!!!

[FDibbins]

Happy to help, and thanks for the kind words - cookies would be great, but the thought is even better