Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
122
Views
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
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