Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a table like the below. I'd like to say
IF [Due Date] is before TODAYS DATE then, colour the cell RED
I have the below so far:
IF([Target Date] ={'>$(=date(today(),'dd/mm/yyyy''))'} and [Action Status]='Open',LightGreen(), yellow())
Can you help me get this right?
May be this?
IF([Target Date] =date(today(),'dd/MM/yyyy') and [Action Status]='Open',LightGreen(), yellow())
Or, even
IF([Target Date] =today() and [Action Status]='Open',LightGreen(), yellow())
May be this?
IF([Target Date] =date(today(),'dd/MM/yyyy') and [Action Status]='Open',LightGreen(), yellow())
Or, even
IF([Target Date] =today() and [Action Status]='Open',LightGreen(), yellow())
mm takes as minitues so u can use 'MM'