Forum Discussion
radwansam_
Apr 28, 2023Copper Contributor
Color coding by changing dates giving me grief
Hi! would appreciate anyone's help on this. I am trying to color code rows based on similar dates as shown: i tried this code which worked till row 107 for some reason.. can anyone help ...
- Apr 28, 2023
Up to and including A106, the cells contain only a date (with midnight as time).
Starting in A107, the cells contain a formula that returns the date AND time - it uses NOW().
Solution:
- Manually, type the date 4-27-23 (without time) in A107:A111.
- Change the formula in A112 to =IF(B112<>"",IF(A112<>"",A112,TODAY()),"")
- Double-click the fill handle in the lower right corner of A112 to fill down.
HansVogelaar
Apr 28, 2023MVP
Up to and including A106, the cells contain only a date (with midnight as time).
Starting in A107, the cells contain a formula that returns the date AND time - it uses NOW().
Solution:
- Manually, type the date 4-27-23 (without time) in A107:A111.
- Change the formula in A112 to =IF(B112<>"",IF(A112<>"",A112,TODAY()),"")
- Double-click the fill handle in the lower right corner of A112 to fill down.
- radwansam_Apr 28, 2023Copper ContributorThank you so much! completely missed that