Forum Discussion
I want to create a conditional formatting based on the value of form control checkboxes
I'm creating a checklist type and inserted checkboxes from control of unformatted formats, taking as the right cells of each of the checkboxes. And I wanted to create conditional formatting that applied to the value of each box (True or False), but I can not do that. Please, I'll help!
3 Replies
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.
Okay, good
