3D references

Hi Liz_Park,

To extract mitigations from a risk assessment report in Excel, especially when the report uses conditional formatting to highlight concerns in red, you can use the following steps:

1. On the summary page where you want the mitigations to be displayed, in the cell where you want the first mitigation to show up, enter the following formula:

=IF(Sheet1!B1=TRUE, Sheet1!A1, "")​

This formula checks if the cell in column B of "Sheet1" is in red (indicating a concern), and if so, it displays the corresponding cell from column A, which should contain the mitigations. If it doesn't meet the condition, it shows an empty string.

1. Hit Enter to apply the formula.

2. Use the fill handle (it's a small square at the bottom-right corner of the cell) to drag the formula down to fill all the cells in your summary sheet where you want the mitigations.

This process will populate your summary sheet with the mitigations from "Sheet1," precisely where the red conditional formatting indicates concerns.

Please note that you will need to customize the sheet names, column references, and ranges as per your specific Excel workbook setup.