i have a work tracking sheet. in sheet EA cell S14 is yellow. i want that it should show up red when it is blank on the date pass. for example S14 work had to be done on 27th feb. but still that work is not done. i want that this is late and not done so this need to be red. if the work gets complete on 28th feb or today that will become red(formula already applied) but now i want that if that not get done on that particular day. then also it should show up red even if done late and even if is empty. for all late cells also like v17, v18 and many more.
please do this. i am hoping that this will also be get solved
here is the link of file.
https://docs.google.com/spreadsheets...gid=1924994592
Bookmarks