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