How to Align Bold Word Left or Right

[Roco]

I'm trying to do 2 things. I'm working with MS Excel 2013 with a sheet named "Proposal".

1. What I would like to do is in Cell A30 thru A162 if a word shows up as bold I need it to align to the left. This cell is pulling information from "=Sheet1!A9 thru =Sheet1!A141" Some of the cells will show numbers, which I would like to align to the center.

2. Starting on Line 30 thru 162 I have merge BCD as one cell. In this location if a word shows up Bold I need to align it to the right. This cell is pulling information from "=Sheet1!B9 thru =Sheet1!141.

I would really appreciate your help on this.

[quekbc]

Try this code here.

NOTE: Remember to save your file before running this code as a back-up.

Please Login or Register  to view this content.

[Roco]

thanks...I copied the code and put it in a module but it didn't align anything. Got anything else?

[quekbc]

It worked on a dummy spreadsheet I wrote.

Are you able to provide a sample of the workbook you are working on? With all the sensitive information removed of course.

[Roco]

I was really busy last couple of days but here is a copy. I have entered some information so that it would transfer to the proposal sheet. I hope this will help you with what I would like to do. Thanks in advance.

[quekbc]

Right, the words there are not formatted as bold as per normal but done so using conditional formatting. The rule for the formatting seems odd but here's the code following the same logic. I.e. if the cell contains the letters b, c, w, r, e, d, s then format it as bold.

Similarly, for the 2nd part (column BCD), the conditional formatting is based on whether the cell contains the word "total".

I've changed the code accordingly.

Please Login or Register  to view this content.

[Roco]

Thumbs Up...I appreciate it. It works great.

[Roco]

Would like to have you do one more thing if you could. Everything you have done so far works great. In Column G on the proposal sheet where the subtotal now shows up in bold and to the right, I would like for the number in column G in the same row to show up Bold. I would appreciate it a lot and it would save me a lot of time. Thanks

[quekbc]

For that, you can use conditional formatting. Follow these steps:

1) Select cells G30:G162
2) Home tab --> Conditional Formatting --> New Rule...
3) (Top half) Select a Rule Type: Use a formula to determine which cells to format
4) (Lower half) Format values where this formula is true: Type / paste this formula in

Please Login or Register  to view this content.

5) Click on Format
6) Font tab --> Font style: Bold

[Roco]

(Solved) Thank You so much..

1) Select cells G30:G162
2) Home tab --> Conditional Formatting --> New Rule...
3) (Top half) Select a Rule Type: Use a formula to determine which cells to format
4) (Lower half) Format values where this formula is true: Type / paste this formula in

Please Login or Register  to view this content.

5) Click on Format
6) Font tab --> Font style: Bold[/QUOTE]

[Roco]

Solved.....Thank You so much...

[quekbc]

Happy to help. Thanks for the rep!