I have a google spreadsheet with multiple rows, a few hundred. and in row "D" there are the dates the entry was added. i need that date to turn a color after 24 hours have passed. could use any help, thank you!

CodePudding user response：

since you already have dates added either via timestamp script or google form then enter conditional formatting and try:

=((NOW()-D1)>=1)*(D1<>"")