Conditional Formatting based on Checkbox
Closed
EClem
Posts
1
Registration date
Thursday December 4, 2014
Status
Member
Last seen
December 4, 2014
-
Dec 4, 2014 at 11:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 8, 2014 at 11:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 8, 2014 at 11:35 AM
Hi,
I've been trying to conditionally format a merged cell by what happens to a checkbox. If my checkbox is blank and the control cell in B16 is "FALSE", I want my merged cell to be grey in color. I have tried SEVERAL Conditional format equations such as:
Formulas:
=$B$16="FALSE"
=IF($B$16="FALSE"), IF($B$16="TRUE")
Please help!!
I've been trying to conditionally format a merged cell by what happens to a checkbox. If my checkbox is blank and the control cell in B16 is "FALSE", I want my merged cell to be grey in color. I have tried SEVERAL Conditional format equations such as:
Formulas:
=$B$16="FALSE"
=IF($B$16="FALSE"), IF($B$16="TRUE")
Please help!!
Related:
- Conditional Formatting based on Checkbox
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history ✓ - Facebook Forum
- How to clear formatting in excel - Guide
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- Based on the values in cells b77 b81 c77 - Excel Forum
- Phone formatting software for pc - Download - File management
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 8, 2014 at 11:35 AM
Dec 8, 2014 at 11:35 AM
Hi EClem,
You shouldn't treat the FALSE statement as a value.
Try:
=$B$16=FALSE
Best regards,
Trowa
You shouldn't treat the FALSE statement as a value.
Try:
=$B$16=FALSE
Best regards,
Trowa