Is there a way to make a checkbox automatically format a row?

robgoldstein

Board Regular
Joined
Oct 26, 2013
Messages
103
I have a sheet where I have a checkbox that is entering TRUE or FALSE into a cell. For some reason I can't seem to get those values to control the conditional formatting for that row based on those text inputs. I have a rule already setup when that cell contains "n". Is there a way I can make "TRUE" act the same as "n"
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
Why not just change the rule to TRUE rather than "n", note do not use quotes in the rule for logical values.
 

robgoldstein

Board Regular
Joined
Oct 26, 2013
Messages
103
I tried that and it didn't work. What I ended up doing was attaching it to the cell next to it, then making an if statement to insert an "n" in the right cell. I was surprised the condition didn't work on True or False.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
What was the rule that you used?, because it does work with true/false.
 

robgoldstein

Board Regular
Joined
Oct 26, 2013
Messages
103
The rule was if the cell equaled "n" format the line red. I changed the n to true and it didn't work.
I figured out a workaround.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
Did you enter TRUE, or "TRUE"?
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,666
Hello,

You can also assign your format macro to your checkbox ...

Hope this will help
 

Forum statistics

Threads
1,078,213
Messages
5,338,891
Members
399,265
Latest member
aj17x55

Some videos you may like

This Week's Hot Topics

Top