chamblessw
New member
- Joined
- Mar 10, 2013
- Messages
- 7
- Reaction score
- 0
- Points
- 0
I want to write =If(Sheet1!A2=Yellow,0,Sheet1!A2). That is, I am copying data from sheet 1 to sheet 2. I want to be able to invalidate a few cells by manually coloring them. Therefore, I want all cells that I manually color in sheet1 to show 0 in the new cell. Conversely if sheet1!A2 is not colored and contains a numeric value of 6, I want the new cell to show 6.