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
Apply conditional formatting to the selected cells ✓ - Excel Forum
Conditional formatting if two cells match ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text - Excel Forum
How to clear formatting in excel - Guide
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum

1 response

Answer 1 / 1

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

How to use conditional format based on text?

Highlight cell if another cell contains specific text

How do I change a base location on Instagram?

help me to add particular cells

Highlight cell if another cell contains any text

Similar discussions

Subscribe To Our Newsletter!