Conditional format row based on whether a related table record is complete

[Nicholas_black]

Hi There

I'm having trouble with an expression for conditional formating. I want the row to change when all the related table records are marked as complete at the moment i am using the below but its not working and wondering if anyone has any tips on this as unsure if i should be using a select expression or similar. 

AND([Customner date]<today(),[related parts 2].[Status]=1,) 

Thanks

[Marc_Dillon · Accepted solution]

COUNT(SELECT( [related][key] , [status]='complete' )) = COUNT([related])

Or possibly:

ISBLANK(SELECT( [related][key] , [status]<>'complete' ))

[Nicholas_black]

Count worked a treat thank you very much