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 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 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!!

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
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
0