Selecting Row based on a Cell Value

[ERed1]

Hi all,

I have data that is always changing. I need a macro that searches through column AH for the word "Black". If the word "Black" is found then that row gets selected and the font gets changed to red. I have to code for the red font, I just cant figure out how to select the specific row.

Here is the code for the red font:

With Selection.Font
.Color = -16776961
.TintAndShade = 0
End With

Thank you in advance!

 

[Fluff]

Why not use conditional formatting, rather than a macro?
Also do you want the font for the entire row to be red, or just that cell?

 

[ERed1]

I didn't even think about that. I would I set up the rule for it? I haven't used conditional formatting before.

 

[Fluff]

Depends on the answer to my 2nd question

 

[ERed1]

Haha didn't see that. I would like just the font to be red if possible.

 

[Fluff]

For the whole row, or just the cell in col AH?

 

[ERed1]

The whole row should have red font, if the cell in AH has "Black" as a cell value.

 

[Fluff]

Ok, select your data & then in Conditional Formating > New rule > Use a formula & enter
=$AH2="Black"
Then select the format & Ok.
This assumes that the first row you selected is row 2, if not change $AH2 to match the first selected row.

 

[ERed1]

Ok, select your data & then in Conditional Formating > New rule > Use a formula & enter
=$AH2="Black"
Then select the format & Ok.
This assumes that the first row you selected is row 2, if not change $AH2 to match the first selected row.

This worked perfectly. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback