up vote 2 down vote favorite
share [g+] share [fb]

My long list of data has numbers in Column A, but in random rows. How can a macro be written to find a number in Column A and then bold the corresponding data in that row?

I know if I record my actions as a macro it's not going to work. Any help or code would be really appreciated.

Many thanks

Michael

link|improve this question
89% accept rate
feedback

2 Answers

up vote 3 down vote accepted

This WikiHow article explains how to do conditional formatting in detail.

link|improve this answer
+1: Conditional formatting is the easiest way to achieve this. – Mike Fitzpatrick Jun 28 '10 at 10:40
Hadn't thought of CF. Tried it and it worked. – Mike Jun 28 '10 at 10:52
feedback
up vote 0 down vote

Can't you just select the entire column by clicking the column name and then press ctrl+b? Or does the column have mixed content types?

link|improve this answer
Not all the rows in Column A have numbers, and it's only those that with numbers that I need to make bold. – Mike Jun 28 '10 at 10:41
feedback

Your Answer

 
or
required, but never shown
discard

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