We require an excel VBA Scipt(s) to change formatting through out a spreadsheet.
- Based on a numeric code in one column, apply a series of formats across columns in that row
- Macro button to toggle the formatting
- Copy data + formats, and do simple division formula on a new tab
See attached spreadsheet sample for overview.