Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
Trying to format table cell with formula:
if(([EightD.D4_KPIDate]= '31/12/9999', Today()-EightD.D1_KPIDate)>'15', RGB(115,205,170))
but this is not returning no cell colour.
Any ideas?
Thanks
Hi @JoseGarcia
two errors here
first, the if statement should be
if(condition,format1, format2)
for nested if
if(condition,
if(condition,format1, format2)
, format3)
Second, for comparing numbers you should not use single quote.
Today()-EightD.D1_KPIDate>15
Hope this helps.
best,
Help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂
Hi Jose, its most probably because of the wrong if and else statement, you need to create to if and else conditions if you want to give color to each value, because in the current instance you are giving color only to the else statement, not to all the values.
Hi @JoseGarcia
two errors here
first, the if statement should be
if(condition,format1, format2)
for nested if
if(condition,
if(condition,format1, format2)
, format3)
Second, for comparing numbers you should not use single quote.
Today()-EightD.D1_KPIDate>15
Hope this helps.
best,
Help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂
Woow, explanation explanation worked! Great post! Thanks a million!