Forum Discussion
Color a cell the same as another cell's fill color
Greetings. I've searched through the Excel community for how to do this, but all I find is conditional formatting which doesn't seem to work for my case. I have a spreadsheet with a week by week sc...
Depending on your Excel settings, you may need to enable macros. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and choose the appropriate option. Remember to save your workbook as a macro-enabled workbook (.xlsm) to retain the macro code. If you encounter any issues, use breakpoints or MsgBox statements in the VBA code to help with debugging.