Previous Topic Next Topic

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

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
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses