Forum Discussion
Solved
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 “Wi...
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
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
