Bold font for Location Totals

[Guest]

I am trying to bold the 'Location Totals' within a macro. Any suggestions?

703.54
Loc 9 10067 TILLMAN, CHARLOTTE
Loc 9 10412 HUDSON, DESMOND
Loc 9 10716 TURNER,TERRENCE L
Loc 9 9 Location Totals
Loc 16 8338 LEYVA, ADOLFO
Loc 16 16 Location Totals
Loc 17 8980 ODUNZE, KELECHI C
Loc 17 17 Location Totals

 

[Guest]

You could do this by choosing conditional Formatting under Format menu, then
select 'is equal to' and type 'Location Totals' and then pick bold font type
and click ok, ok.

 

[Guest]

Hi Adnan,

I tried your suggestion, but it didn't bold the text. I'm obviously missing
something. And, is there any way to bold the entire row?
Thanks.

 

[Dave Peterson]

Select the whole range.
with the activecell in row 2 (headers in row 1???)
format|conditional formatting
formula is:
=$c3="Location totals"

The $c means that the formula will always point to column C.

The 3 (without the $) means that the formula will adjust to the row--just like
copying a formula in a cell.

 

[Guest]

Dave -
I selected the entire range from Loc to Order - inserted the formula
=$d8="Location Totals" - still didn't highlight totals......what am i
missing. Thanks.

Loc Empl# Employee Name Mt Order


9 10067 TILLMAN, CHARLOTTE DP 4431420
9 10412 HUDSON, DESMOND DP 3210611
9 10716 TURNER,TERRENCE L OF 3869217
9 9 Location Totals 3
16 8338 LEYVA, ADOLFO OF 10785200
16 16 Location Totals 1
17 8980 ODUNZE, KELECHI C I6 10749507
17 17 Location Totals 1

 

[Guest]

THANKS DAVE.....I got it!!

Select the whole range.
with the activecell in row 2 (headers in row 1???)
format|conditional formatting
formula is:
=$c3="Location totals"

The $c means that the formula will always point to column C.

The 3 (without the $) means that the formula will adjust to the row--just like
copying a formula in a cell.