Bolding Cell in Excel

[Queryman]

I have multiple worksheets that have the word "TOTAL" in a cell in a column. I need to bold this cell. It appears in the same column but not always on the same row, is there a way to set this in the excel sheet or using VBA code.
Thanks

Michael

 

[hopelessliar]

How about conditional formatting? Highlight the column and use

cell value >> is equal to >>total
then apply the bold format.

This should work fine.

 

[Queryman]

Thanks that worked, a slight twist. If I need the whole row boded where the word "Total" appears, how would I do that. I have multiple worksheets and in each worksheet this is always the last row, if that helps. So instead of looking for the word "total" is it easier to look for via code for the last row of each worksheet in my output which has hunderds of tabs in the workbook

Michael