Copy data from specific cells in one sheet that has condtional formating to another excel sheet

[bustosjuan]

I have two spreadsheets.​

Sheet1 has data description in Column A and B (which are conditional formatted), and Column C has a predetermined value (0, 1 and N/A), When the value selected in Column C is "0" then the cells to the left in column A and B (Code and Description) change their font to Yellow and their shadow to Red. I would like to transfer automatically to another sheet (Sheet2) any code and description that change to Red shadow and yellow font when in column C has been selected the value "0".

For this example, I will just change the font color to a Red in Columns A and B for the conditions that met the Value "0" in column C.
So, any cell data in Sheet1, contained in Columns A and B whose value has changed to "0" from a predetermined list (0,1, N/A) must be sent to Sheet2.

SHEET1
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Code[/TD]
[TD]Permits/Authorizations Used[/TD]
[TD="align: center"]Value (0, 1, N/A)[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Part A Work details[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Part B Work scope & description[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]N/A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]103[/TD]
[TD]Part C Specialty safety equipment[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD]104[/TD]
[TD]Part D Safety precautions[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]105[/TD]
[TD]Part E Work authorization[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]












Then I would like only to transfer those date that met the condition to change to red when the value in column Change to "0".
So, any Code in column A (Sheet1) that change will be sent to Sheet2 at the Colum A (Item#)
and Description in Column B (Sheet1) that change will be sent to Sheet2 at the Colum B (Deficiencies/Hazard Identified)
I will write as an example in table (Sheet2) to show what is the information should be appear automatically in Sheet2 from Sheet1.

SHEET2
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Item #[/TD]
[TD]Deficiencies/Hazards Identified[/TD]
[TD]
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Detailed Location[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]103[/TD]
[TD]
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Part C Specialty safety equipment[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]105[/TD]
[TD]Part E Work authorization[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]











I am very new in excel and even I have tried hard I do not know how to do it. And English is my second language and already the encrypted language of excel is quite difficult for me to understand everything. I could say I have the basic excel skills. I would really appreciate to someone that could help me with this issue. I am also VERY NEW in this tool.

Thank you in advance to the good Samaritan who will help me with this.
Juan