Forum Discussion
IF Statement? Or conditional formatting... How?
Queston 1:
=IF(C2="", "", EDATE(C2, 3))
Question 2:
Select D2:D100 or however far down the data extend. D2 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=$E2="Yes"
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.
Queston 1:
=IF(C2="", "", EDATE(C2, 3))
Question 2:
Select D2:D100 or however far down the data extend. D2 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
=$E2="Yes"
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.