How to turn cell into green with a specific condition?

Fixed with this:

procedure Form1_TableGrid1_OnChange (Sender: string);
var
   i,c: integer;
   s: string;
begin
     c := Form1.TableGrid1.RowCount - 1;
     for i := 0 to c do
     begin
         s := Form1.TableGrid1.Cells[1,i];   // Edit Tcoton: count the column from 0, it was checking the column after the received date
        // if ValidDate(s) then     -- Edit Tcoton, does not work if active
             if (StrToDateTime(s) + 5) < now() then Form1.TableGrid1.Cell[12,i].Color := clRed; //Edit Tcoton: Use StrDateTime instead of StrToDate and add () after now
             if form1.TableGrid1.cells[12,i] = 'Filed' then Form1.TableGrid1.Cell[12,i].Color := clgreen;
     end;
end;

Hi,
The 'hotspots' should work irrespective of whether your document locations point to the original location or point to the 'copyto' location.
It's generally not such a good idea to use 'storefile' for your documents, photos etc as the size of your application can quickly get very large.  I normally select 'linkfile' and choose a 'copyto' location so that all the documents which may have come from any number of places all end up saved to a single location;  an 'attachments' folder within the MVD app folder is fine but it could be any location (specific machine, LAN or WAN).
If you want your attachments to be seen by all users, then the folder they are saved in needs to be shared;  just sharing the sqlite.db is not enough when you use 'linkfile' for your attachments - the database points the users to the linked file but if that location isn't shared, they won't be able to see anything (if you were to use 'storefile' this wouldn't be an issue because the actual attachment is part of the database, not just a pointer).
I've changed your app so that it now hotspots on Column 2 (Doc Title), Column 7 (Attachment 1), Column12 (to see the Document Flow History) and Column 13 (Attachment 2 (Signed Doc).  It's a useful trick when using multiple hotspots to just put an '*' in the Column Heading in the tablegrid to remind users about the feature.
A couple of other things.  Your Attachment2 wasn't working because you weren't saving it (Form2 Button4).  Also, you might want to define Attachment 1 and Attachment 2 in your database as 'file' rather than 'image';  as it is, they can't be .txt, .doc etc file types (I just find using 'file' is less restrictive, but it might not be an issue for you).
Hopefully, it's all working okay now.
Derek.