Conditional formatting for rows containing text

[terrapinie]

Is it possible to conditionally format for rows containing certain
text? I receive a weekly report of hours and costs from our financial
department that I need to sort and enter information into a
spreadsheet for actuals vs. budget. This information comes to me with
column A looking similar to this:

1234 Sum of Total Hours
1234 Sum of Total Cost
1235 Sum of Total Hours
1235 Sum of Total Cost
1236 Sum of Total Hours
1236 Sum of Total Cost
1237 Sum of Total Hours
1237 Sum of Total Cost

with the #'s being different charge numbers. I would like to make,
say, every column for hours filled with a different color, to make
reading & transferring the information easier. If it was me creating
the spreadsheet for the report, I would've put charge # in one column
and the Text in the next column; this would make sorting much easier,
but unfortunately, I do not have control over this.
I would like to have a conditional format (or macro, or formula that I
can enter into another column) that works like this:
If $A1 contains "Total Hours" format whole row .......

Is this at all possible??

Thanks,
Laurie

 

[DDM]

Terrapinie, like this:

1-Select Cell A1
2-Press Ctrl+A
3-Format > Conditional Formatting
4-Formula is =FIND("Total Hours",$A1)
5-Set up your format

Format will kick in for the whole row any time "Total Hours" appears in
Column A.

 

[terrapinie]

Thanks a ton - this will really help to highlight and differentiate
between rows. I do love the Google Groups!!!!!

Thanks again,
Laurie