| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bold a line
Select all your rows that can (or could eventually) have data in them and
use this formula in the Conditional Formatting dialog (don't forget to select the Bold property for the Format/Font tab)... =COUNTIF(1:1,"*total*")0 -- Rick (MVP - Excel) "Thomas Roos" wrote in message ... Let me clarify this a little more. I have lots of rows that I want to evaluate. The cell will contain more than the word Total The column of text will have more than one row with the word Total in it. How do I solve this problem. Thanks -- Tom "Mike H" wrote: Hi, Select the row then format|Conditional format - formula is enter the formula =$A1="Total" Pick a colour - OK Mike "Thomas Roos" wrote: I want to bold an entire row if the cell in the first column contains the word Total. How would I do that? Thanks -- Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alphabetically list of last names: BOLD, not bold | Excel Discussion (Misc queries) | |||
| Alphabetically list of names BOLD and NOT bold | Excel Discussion (Misc queries) | |||
| How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
| Bold & add line after subtotal row | Excel Worksheet Functions | |||
| Join bold and non-bold text in one cell | Excel Discussion (Misc queries) | |||
Threaded Mode
