How to find values in a range in a sheet? – MS Excel 2007 Tips

Filling or finding values in a sheet pertaining in a range can be accomplished easily using conditional formatting. The previous post spoke about finding duplicate values in a sheet. This post talks about this topic further.

Suppose you have the following set of numbers and you wish to find numbers which are between 45 and 115.

Conditional Formatting Range - MS EXCEL 2007
Conditional Formatting Range - MS EXCEL 2007

You could do it in the following steps:

Type Alt+h+l. This would open the following box of conditional formatting

Conditional Formatting Range Toolbar 1
Conditional Formatting Range Toolbar 1

Select the first option Highlight Cell Rules.

Select the Between option, which would open the following box:

Conditional Formatting Range 2
Conditional Formatting Range 2

Enter 45 and 115 in the field two fields (values within which you want to search the data).

And then select “Light Red fill with Dark red text “ or any option in that drop down list to highlight the required cells.

Conditional Formatting Range Result
Conditional Formatting Range Result

As can be seen, the conditional formatting box has several options such as greater than, less than, equal to, text that contains and so on. By clicking on either of the options you would be presented with a window (as seen above in Between) where by entering the required values, you would get the desired results.