Forum

Notifications
Clear all

conditional formatting

2 Posts
2 Users
0 Reactions
122 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

In the attached file I want to set up with conditional formatting
That when Boy marks the box, the data will be filled with yellow
I have already defined a rule within conditional formatting -
He does not work for me, why? What's wrong with the formula I wrote?
Thanks

 
Posted : 30/05/2019 6:23 am
(@fravis)
Posts: 337
Reputable Member
 

Hi Lea,

The outcome in J1 is TRUE or FALSE. So in your conditional formatting you have to take that and not 1 and also not text quotes or so.

The formula is =$J$1=TRUE and that'll work.

Frans

 
Posted : 30/05/2019 1:39 pm
Share: