Conditional Formatting Based on the Adjacent Cell

[LtCmdrData]

I have some data subtotaled in column A. For each row that contains "Total" in column A I want to fill the adjacent cell in column B with the color Green. I know I can accomplish this using Conditional Formatting and a formula but I'm not sure how to write the formula. Could someone please help me? Also I want to include this in a macro where I perform some other tasks. Thanks.

 

[mumps]

For Conditional Formatting, this formula would have to go in column B starting at row 2: =A2="Total"
If you want to include this in a macro, then you won't need the conditional formatting. Please clarify.

 

[LtCmdrData]

It will be included in a macro so could you please explain the code I need to accomplish this task? The macro is to add borders to all the cells in the data area plus I want to add a thick border around every subtotal. Thanks.

 

[mumps]

Can you post a screen shot of what your data looks like? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells and worksheets. If the workbook contains confidential information, you could replace it with generic data.