SOLVED

Formatting multiple cells based on one cell value in a macro

Copper Contributor

I need to format multiple cells on a row, based on the value of one cell on the row, and repeat for all occurrences in the spreadsheet.  In the attached example, I need to find all occurrences of “Window” in column C, and then format (Bold and Yellow fill) the cells in columns A, B and C in the same rows.  The number of rows in the spreadsheet can vary.

3 Replies
best response confirmed by LonnieCurrier (Copper Contributor)
Solution

Hi @LonnieCurrier 

 

Do you prefer macro as this can be achieved without using macro.

 

Just use conditional formating with "use a formula to determine cells to format" option and use the following formula

 

=$C2="Window"

 

I have attached a sample for your perusal.

 

Cheers

 

@wumoladThanks!  I tried recording this as a macro and it worked well.  Thanks again

Good to know it was useful.

Cheers
1 best response

Accepted Solutions
best response confirmed by LonnieCurrier (Copper Contributor)
Solution

Hi @LonnieCurrier 

 

Do you prefer macro as this can be achieved without using macro.

 

Just use conditional formating with "use a formula to determine cells to format" option and use the following formula

 

=$C2="Window"

 

I have attached a sample for your perusal.

 

Cheers

 

View solution in original post