Showing Value Conditionally
There is an Excel file that teaches how to perform the Showing Value Conditionally operation.
Excel Spreadsheet for Showing Value Conditionally
This workbook demonstrates showing value conditionally using VBA macros on a 22-row data layout.
Hope it is useful.