1

I have a schedule where I use inspector name, job number and then checkboxes to book the inspector on the visit date

enter image description here

What I'm looking to do is if an inspector is booked in a job on lets say jan 3rd and then in another job also in jan 3rd then fill the cells (Inspector name, job and date checked) in yellow then, if an inspector is booked for 3 jobs on the same day fill the cells (Inspector name, job and date checked) in red

Example:

enter image description here

If someone can help me to figure out a conditional format formula for this it would be much appreciated

  • The default values for checkboxes are TRUE and FALSE. If your checkboxes use the default values, the fhe formula could look this way: =A4 Do you know how to set a custom formula for conditional formatting? – Rubén Jan 8 at 23:47
  • Rubén what do you mean =A4? – Pablo Briones Jan 9 at 1:58
  • I have no clue 🙁 – Pablo Briones Jan 9 at 1:59
  • There are already several answered questions you might find helpful like webapps.stackexchange.com/q/79846/88163 Also look the list of Related questions to the right. If after studying some of them you still need help, please update the question. Tip: include a link to a demo spreadsheet shared with anyone with the link to view. – Rubén Jan 9 at 2:32
  • Non of them cover what I’m looking to acomplish – Pablo Briones Jan 9 at 2:35
0

The default values for checkboxes are TRUE and FALSE. If your checkboxes use the default values, the conditional formatting custom formula should look this way:

=A4

In the context of the conditional formatting feature of Google Sheets that means apply the conditional formatting when the value of A4 is true. Instead of A4 you should use as reference the cell address of the top-left cell cell of the range with the checkboxes for be formatted.

Please note that A4 is a relative reference.

References

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.