Editing Formula Conditionally
There is an Excel file that teaches how to perform the Editing Formula Conditionally operation.
Excel Spreadsheet for Editing Formula Conditionally
This workbook demonstrates editing formula conditionally using VBA macros on a 21-row data layout.
Hope it is useful.