Forum Discussion
Conditional Formatting
Hello, I am trying to create a rule for a spreadsheet we are using to keep track of attendance for an upcoming event. Basically, we have 2 columns, Column D for "Yes" and Column E for "No". I...
Thank you! When I do the rule for Column F it deletes the email address but in the row below the one it should be deleting... so it's making the wrong email address go away
When you create the rule, the formula should refer to the row of the active cell.
I assumed that your selection would begin in F2, so the formula refers to D2:E2.
If your selection begins in F1, the formula should refer to D1:E1 instead.
- the second formula is not working. How do I get the email address in column C to copy and paste to column G when "yes" is marked in column D?
=IF(D2="Yes", C2, "")
- that is not working for some reason. is "" supposed to be the copy and paste feature?
HansVogelaar that might be what I was doing wrong. Thank you!