Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Intermediate Excel Error Checking Prevent Errors Using Data Validation

Posted by Steve Nicksic
Steve Nicksic
8,968 Points

"Circle Invalid Data" for Multiple Cells Not Working

When I select the highlighted cells, in Warning mode, and choose "Circle Invalid Data", why does it not work when I enter a whole number outside of the set parameters?

I type in a negative number, which is invalid, the Warning message comes up and I choose to keep the data. Then the value stays but is not circled. I have tried clearing and starting over but only works on individual cells where a value is already entered and only after I select that cell and click "circle invalid data". I get how this should work but it is not working for some reason. Am I missing something?

Steve Nicksic
Steve Nicksic
8,968 Points

Is this suppose to be only an "after the fact" deal? I guess that would make sense.