Table cell colour formatting

[JoseGarcia]

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

[deepanshuSh]

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. 

[RafaelBarrios · Accepted solution]

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! 🙂

[JoseGarcia]

Woow, explanation explanation worked! Great post! Thanks a million!