I have work tracking file. all is running good only i want to have conditional formatting in it.
for example:- in sheet dme, column f12:f50 is for planned work. all the dates in f12:f50 are sign of planned work column g12:g50 is for actual work dates(when the work is getting done, actually)
my requirement is that if f12 is not blank and g12 is blank for today then g12= yellow colour
and if f12>= g12 then g12= green colour.
if f12<g12 then g12= red colour
if f12 is not blank and g12 is blank and planned date has gone then also g12=red colour( if f12 = 4 nov2019 and g12 is blank and today date is 5-11-2019 then it should be automatically red even if blank.) and so on for all the cells.
please see sheet desire result. looking after for the answer.https://docs.google.com/spreadsheets...#gid=177123027