ExcelBanter - Format cells in Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Format cells in Excel 2003 (https://www.excelbanter.com/new-users-excel/242655-format-cells-excel-2003-a.html)

Mazin H

Format cells in Excel 2003

I have column A with text & column B blank or with percentages. I would like
column A to be formated bold when column B is blank!

Example:

Now What I would like
A B A B
smith "Blank" smith(bold) "Blank"
mark 0% mark(norm) 0%

Gary''s Student

Format cells in Excel 2003

1. click on A1
2. Format Conditional Formating... Formula is =b1=""
3. pick Bold
4. copy this format down the column
--
Gary''s Student - gsnu200903

"Mazin H" wrote:

I have column A with text & column B blank or with percentages. I would like
column A to be formated bold when column B is blank!

Example:

Now What I would like
A B A B
smith "Blank" smith(bold) "Blank"
mark 0% mark(norm) 0%

All times are GMT +1. The time now is 02:15 PM.