I need help with Google spreadsheet checkmark conditional formatting. Please see the image for a better understanding. When I click on the C2
cells checkmark then automatically A2
cells $10 will be selected and added to the E5
cells. When I click on the B6
checkmark then automatically A6
cells $40 will be selected and added to the E5
cells. Summary of the concept: When I checkmark any cells (from B2
to B9
& C2
to C9
) the same row (From A column) number will be added automatically to the specific cells(to E5
cells). How do I do it?
Sheet Link (I have given edit permission, you can edit it) - Go to sheet link
Aucun commentaire:
Enregistrer un commentaire