Qlik sense table field color change & KPI fonts color change

[Vince_CH]

all, i have two questions regarding qlik sense color conditioning;

1. in the table as below, i want to track the different timeline in the process if the latter is 7 days later than the former, then the background changed to yellow, either if the latter task is not finished yet so far open, it will be calculated with today() to see if the gap is greater than 7 days, if yes, color changes too, my problem with the following expression is, it only works when there is a date in the latter field with color changing, but doesn't work out when the field is empty. what can i write it correctly?

2. in Qlik sense KPI, can i change the fonts color, when the value is below or greater than certain limit. i looked all other posts, it seems not possible without extension, right?

[Vince_CH]

Hello Community, i read some earlier posts regarding change color of empty cell, it seems to be impossible anyhow.

but if to replace the empty cell with 0, does it work out? how to write the expression or load in script? thank you