Fortunately, Visual Basic for Applications’ InputBox function supports this task, so you won’t have to work very hard! You’ll learn how to select a range using InputBox in this article.

End Function Then, show the user how to call the function from conditional formatting as follows (in Excel 2007 and 2010): Select the range where you want to identify formula cells.