Bold font for Location Totals
 

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

Bold font for Location Totals
 

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.
--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"pm" wrote:

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

Bold font for Location Totals
 

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.

"Adnan" wrote:

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.
--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"pm" wrote:

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

Bold font for Location Totals
 

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.

pm wrote:

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.

"Adnan" wrote:

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.
--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"pm" wrote:

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


--

Dave Peterson

Bold font for Location Totals
 

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


"Dave Peterson" wrote:

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.

pm wrote:

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.

"Adnan" wrote:

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.
--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"pm" wrote:

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


--

Dave Peterson

Bold font for Location Totals
 

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

"Dave Peterson" wrote:

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.

pm wrote:

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.

"Adnan" wrote:

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.
--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"pm" wrote:

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


--

Dave Peterson