| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I bold just the totals when using Subtotals? | Excel Worksheet Functions | |||
| How to show only bold font ? | Excel Worksheet Functions | |||
| Fomatting part of a formula to be Bold font | Excel Worksheet Functions | |||
| Bold the totals of a sub-total. | Setting up and Configuration of Excel | |||
| Are sub-totals able to be set to be bold automatically? | Excel Discussion (Misc queries) | |||
Linear Mode
