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

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!!

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
Clear formatting in excel - Guide
Based on the values in cells b77 b81 c77 - Excel Forum
Phone formatting software for pc - Download - File management
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

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

Highlight cell if another cell contains specific text

help me to add particular cells

How to use conditional format based on text?

How do I change a base location on Instagram?

Fill adjacent cell with number from text answer

Similar discussions

Subscribe To Our Newsletter!