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 want to find a way so that if something is marked in either of these columns, the email in Column F disappears.
I would also like to find a way so that if you mark something in Column D for "Yes" the email then moves to Column G.
If this possible?
Thanks!
1) Column F.
Select F2:F100 or as far down as you want.
F2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula =OR(D2:E2<>"")Click Format...
Activate the Number tab.
Select Custom in the list of categories.Enter ;;; (three semicolons in a row) in the Type box. This will hide the contents.
Click OK, then click OK again.
2) Column G.
In G2, enter the formula =IF(D2="Yes", F2, "")
Fill down.
- 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.
