Help to write a macro in vba excel !

[crazii]

Hello,

I was wondering if someone can help me write a macro that does the following:

there are a list of questions:

Question 1

(other info)

Question 2

(more info)

Question 3

(info about Q3)

.. etc.

I want to create a macro which will find the cell containing "Question 1", "Question 2", etc..and make the entire row be highlighted grey and bolded in white and underlined. There can b upto 30 questions or more.

 

[crazii]

Ok, please do if you have time

Thanks alot for your help !

 

[Stephen_Tsui]

crazii:

In this case no need to use Macro,
Try select the whole range with data,
Select filter -> AutoFilter -> Select the drop down autofilter box of column with the words contain Question-> Custom -> Contains: Question -> Select all the filtered row and change the format u want.

Other Useless data also can be clear by using autofilter

See if it is ok, thx.

 

[crazii]

I tried that but it doesn't work as some questions itself contain the word 'questions'. Thanks for the suggestion though !