Forum Discussion
Formula Assistance Crispin
- Nov 05, 2021
See the attached version.
See the attached version.
- Crispin2410Nov 08, 2021Copper Contributor
Thanks again for your assistance. I have two more columns to address; perhaps you could tackle this challenge as well.
1) In column I, row 4 (I4), I need a countdown that starts according to the date listed in column G, row 4 (G4), "IF" the word "Rejected" is in column H, row 4 (H4). If the word "Accepted" is listed no further action is required.
2) In column J, row 4 once a date is listed the countdown stops in I4 and the cell turns green, regardless if the countdown exceeded the 10 day marker.
Any assistance is very much appreciated!!
Regards,
Crispin
- HansVogelaarNov 08, 2021MVP
It's the same idea as for F4 - see the attached workbook.
- Crispin2410Nov 08, 2021Copper ContributorThank you HansVogelaar!
- Crispin2410Nov 05, 2021Copper Contributor
YES! That is exactly what I am looking for. I hope it was not too difficult.
v/r
Crispin