How to turn cell color if checkbox is checked in Google Sheets

Hello everyone, Today I will present you, How to turn cell color if checkbox is checked in Google Sheets.

Facebook Page:

Twitter:

Please, Subscribe to My Channel:

#google_sheets
#google_sheets_tutorial
#checkbox_in_google_sheets
#google_sheets_conditional_formatting
#turn_cell_green_if_checkbox_is_checked_google_sheets

[vaasukotha]

Very 👌

What is the formula if there are 5 check boxes in the same row? The colour of the row should change if one of them is checked..

[durcastraushun]

the tickbox does work on dropdown cells that has a conditional rule in place.

[mazerackem]

thank you, super easy and to the point!!!

[soniajupp]

thank you, super easy and to the point!!!😍

[tryingtobeproductive]

A2:Z5000 will grab all the rows minus the header so you dont have to hard code them

[DianaHernandez-yjwn]

This helped me a lot. Thank you so much ❤

[CarlosWashingtonMercado]

Hey, thank you. It worked like a charm!

[nadorado]

omgg you're my savior! thank you!!

[DonSantana]

Is it possible to do this but instead of checkboxes. Once anything is in the cell, it will highlight the row next to it.

[FIXITKEEPIT]

Nice speak with a little more Power from stomach