hi to all.
i have a file in which all staff members report their works if they completes. so if any work has to be done on today then the cell of today's date starts to show yellow.if the works completes today and we do yes on today that will become white(normal cell colour). and if the works completes on next day and we do yes that will show red in with today's date.
for example:- see sheet "EA", column S,T. work had to be done on 27th feb. but we filled yes on 15TH march. so that became red. but cell S14 is still showing yellow.
https://docs.google.com/spreadsheets...gid=1924994592
my query is that if the work is not completes today and nothing is filled then it should starts to show red.and when we do yes on next day then also should be red
Bookmarks