May 15 2020 12:43 PM
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.
May 15 2020 03:46 PM
Solution
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
May 15 2020 04:51 PM
@wumoladThanks! I tried recording this as a macro and it worked well. Thanks again
May 15 2020 05:28 PM
May 15 2020 03:46 PM
Solution
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