Format cells in Excel 2003

M

Mazin H

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%
 
G

Gary''s Student

1. click on A1
2. Format > Conditional Formating... > Formula is > =b1=""
3. pick Bold
4. copy this format down the column
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
ASK Field Formatting 1
Bold paragraphs beginning with a number 0
Excel does not accept text format! 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Two columns followed by single page-width column on same page 0
Auto Fill Word Documents 4
Copy addition formula of non-consecutive horizontal cells 2

Top