Conditional Formating
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Conditional Formating
 

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.

--
sb
"Ronan" wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Conditional Formating
 

More info needed but if you
right click on sheet tabview codeinsert 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

"Ronan" wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/