Forum Discussion
Formula Help Request
Currently works: formula: when entering a date (1/1/2025) into C1, D1 = date +2 years (1/1/2027) conditional formatting: when C1 "does not contain blank", C1 cell is green conditional formatting:...
Formula for D1 cell is same as HansVogelaar sir posted to his answer.
=IF(C1="","",EDATE(C1,24))For conditional formatting, use the following rules
=C1<>"" and apply range is C1. Use fill color green.
=D1<>"" and apply range is D1. Use fill color red. See the attached file.