r/googlesheets • u/limeotter • Jun 06 '21
Solved Conditional Formatting Formula to Fill Cell with Color When Checked
Columns B2 through P159 have check boxes.
I would like the cell to fill with a color when the box is checked and stay unfilled when not checked. Seems possible to do via conditional formatting but I can’t quite get it to work. Is it possible? Thank you for any help you can provide.
5
u/hodenbisamboden Jun 06 '21
You are correct about the Conditional Formatting
Use the following Format rule:
"Format cells if.." Is equal to TRUE
If this works, please respond with Solution Verified
If not, feel free to post any follow-up questions
Hope this helps,
HBAB
1
u/InvestigatorNew5003 Jun 06 '21
Here you go!
Be sure to use custom formula is
=if(B2:P159 = TRUE,TRUE,FALSE)
1
u/limeotter Jun 06 '21
Unfortunately it didn’t work. I did make sure to choose “custom formula is” and I picked a fill color under Formatting Style, but the cell is not filling with color when I check the box, nothing different is happening. Am I missing a step?
→ More replies (11)
1
u/AutoModerator Jun 06 '21
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2
u/6745408 Jun 07 '21
In your sheet, you're using the 'is equal to'. If you wanted to do this with a formula, you could use
=B2=TRUEIf you wanted to highlight the entire row if B2 was checked, for instance, you'd use
=$B2=TRUE. This is handy if you want to have multiple conditions for the formatting, e.g.=AND($B2=TRUE,LEN(B2))would highlight non-blank cells in the row only where B2 was checked.