Hi,
For the conditional formatting you need to check if the condition returns TRUE or FALSE. Perhaps the easiest way with checkboxes is to link them to cells and check what these cells returns. Linked cells could be in another sheet which you could hide from the user.
As the sample in attached is conditional formatting for first two records, linked cells are in the same sheet to the right.
