bustosjuan
New Member
- Joined
- Apr 12, 2018
- Messages
- 2
- Office Version
- 365
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
<tbody> </tbody> |
<tbody>
</tbody>
<tbody>
</tbody>
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
Item # | Deficiencies/Hazards Identified |
<tbody> </tbody> | |
103 |
<tbody> </tbody> | ||
105 | Part E Work authorization | ||
<tbody>
</tbody>
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