Hi my friends, I am creating report for my Ap...

[Rafal_Fick]

Hi my friends, I am creating report for my AppSheet. I wonder is there a possibility to force the report to show me conditional formatting for few cells.

Table look like in attached picture.

What I would like to have is that <> (value in %) will be green when it is 100% and if it is less then 100% will turn red if the <> is in the past

Do you think it is possible in Google docs?

[Aleksi_Alkio]

<<IFS([DONE]=1,[DONE])>><<IFS([DONE]<1,[DONE]>> and use the green color for the 1st statement and red for 2nd statement.

[Rafal_Fick]

@Aleksi_Alkio thank you very much.

Is there a way to make it talented also to date? Like if [date]>[now] then <<IFS([DONE]=1,[DONE]>><<IFS([DONE]<1,[DONE]>> and if [date]<[now], [DONE] ? Like this only late deliveries will show colors and the one which are not late will stay with normal color.

I just don’t know how to make this statement

[Aleksi_Alkio]

Something like… <<IFS(AND([DATE]>NOW(),[DONE]=1),[DONE])>> <<IFS(AND([DATE]<NOW(),[DONE]<1),[DONE])>>

[Rafal_Fick]

@Aleksi_Alkio Thank you very much. You solved all my problems

[Aleksi_Alkio]

You’re welcome