Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to make the text of cell A1 bold if the value of B1 is "a"? Is there a formula that can achieve this or do I have to write a macro that can perform this task? Alternatively can I use conditional formatting to convert the text to BOLD

Edit Now how would I perform the same operation if the the formatting needs to happen to the cells in column A based on the value of column B, for example if B1 = a then A1 must become Bold, B2 = b then A2 must be bold and this must happen all the way down the list.

enter image description here

share|improve this question

migrated from Feb 18 '13 at 16:13

This question came from our site for professional and enthusiast programmers.

Yup. I have already voted for it to be moved to :) – Siddharth Rout Feb 18 '13 at 12:38
up vote 2 down vote accepted

Yes you can use conditional formatting

enter image description here

FOLLOWUP (From Comments)

For multiple cells, select the relevant range and simply remove the "$" sign before the row number to make the range relative. See Screenshot below

enter image description here

share|improve this answer
damm, a few seconds faster, I just took the screenshot! ;-) – Peter Albert Feb 18 '13 at 12:37
Thanks for the speedy response, how would i do it with multiple cells further down the sheet without having to create the rule every single time? – Mike Barnes Feb 18 '13 at 12:47
You simply need to remove the "$" sign before the row number after you have selected the relevant cells. Updating with a screenshot – Siddharth Rout Feb 18 '13 at 12:52
I have edited the question please check and see if you can assist? – Mike Barnes Feb 18 '13 at 13:22
@MikeBarnes: I can but I have a quick question. Will it be only 10 rows and values in Col B will be from a to j? If yes, then it is easy else you will have to set separate conditional formatting for each cell. – Siddharth Rout Feb 18 '13 at 14:53

Use Advanced Conditional Formatting.

share|improve this answer
+ 1 too fast :) – Siddharth Rout Feb 18 '13 at 12:36
I didn't take a screenshot :) – Andrey Gordeev Feb 18 '13 at 12:37
The answer is not very helpful for somebody who does not know conditional formatting (as it's a bit hidden). So providing a screenshot or some additional explanation would be helpful... – Peter Albert Feb 18 '13 at 12:38
@PeterAlbert the article describes the problem very well, I don't think it can be more clearer or the text is need to be pasted here. Moreover, OP could find this information by himself. – Andrey Gordeev Feb 18 '13 at 12:41
@AndreyGordeev - fair point, I didn't see the link. I just unclicked my -1 - but acciently double clicked. Now I cannot unclick "until an edit" was done. :-( Can you do a miniedit, so I can remove it? sorry – Peter Albert Feb 18 '13 at 12:48

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.