Forum Discussion
Formatting multiple cells based on one cell value in a macro
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.
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
3 Replies
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
