May 15, 2004

Error! Part 2

Conditional Formatting. It can be used for many things. Let's have a look at how we can use it for error spotting.

In a certain range of cells, all numbers entered must be greater than or equal to 0 and smaller than or equal to 10. One possible formula for the Conditional Formatting in cell B1 for example is =OR(B1<0,B1>10)

Hmmm, let's make it a little more interesting and say that all entries must be multiples of 0.5. Here's my modified formula =OR(B1<0,B1>10,ROUND((B1/0.5),0)<>B1/0.5)

There you have it. Any cell that does not fit all of the above criteria will be highlighted like this.

Have a nice weekend.

Comments: Post a Comment

This page is powered by Blogger. Isn't yours?