title: if cell a1=text then cell a2=bold. How do i do it in excel?
body: <p>if cell a1 is equal to some text then i want to select the corresponding cell in the same row to be in bold and italic. for eg if there is text "james" in cell a1 then i want to make the other cell a2, containing an integer, in bold and italic. This has to be done for a selective range in the worksheet, so wherever there is james i need the corresponding cell to be bold and italic. Please help me out here. </p>