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.