Bold font for Location Totals

P

pm

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
 
A

Adnan

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.
 
P

pm

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.
 
D

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.
 
P

pm

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
 
P

pm

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

Dave Peterson said:
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.
Click to expand...
 
Top