Conditional Formatting

[Jake]

I need to bold any row that has the word total in it.

 

[Jason Morin]

1. Select the rows (starting with row 1).
2. Go to Format > Conditional Formatting
3. Select "Formula Is" on the drop-down list and insert:
=COUNTIF(1:1,"*total*")
4. Click the Format radio button and format as bold.
5. OK out.

HTH
Jason
Atlanta, GA

 

[tc]

Dear Jake:


You may:

Ctrl + A to highlight the whole worksheet

On the menu, choose "Format" -> "Conditional Formating"

Choose "Cell Value" , "Equals to" , type ="Total"

Choose bold type in format, then "OK"

Yours sincerely,

TC

 

[Anon]

This will only format the cell containing "Total", not the whole row.