Conditional Formatting based on Checkbox

Closed
Report
Posts
1
Registration date
Thursday December 4, 2014
Status
Member
Last seen
December 4, 2014
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi EClem,

You shouldn't treat the FALSE statement as a value.

Try:
=$B$16=FALSE

Best regards,
Trowa