Conditional Formating

  • Thread starter Thread starter Ronan
  • Start date Start date
R

Ronan

Hi,

I am quite new in excel so this question might be silly. I am using
conditonal formatting and I'd like a whole line to change color (and
not only the cell) when I find a certain word in a given column. Hope
this is clear.
Thanks

Ronan
 
Ronan,

Select the entire data set. Than go to conditional formating.
Change to 'Formula Is'
than enter =$A1="myword"
Where A is the column you want.
Where 1 is the first row of your selection.
Change as needed to fit your circumstances.

Once you get the hang of this you can record a macro to automate
the process for future needs.
 
More info needed but if you
right click on sheet tab>view code>insert this>

it will turn the active column red if cw is typed into any cell
and change back if anything else is typed into any cell.
Maybe it will help you to get where you want to be.

Private Sub Worksheet_Change(ByVal Target As Range)
'If Target.Column <> 2 Then Exit Sub
If Target = "cw" Then
ActiveCell.EntireColumn.Interior.ColorIndex = 3
Else
ActiveCell.EntireColumn.Interior.ColorIndex = -4142
End If
End Sub
 
Back
Top