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 that are between 45 and 115.
You could do it in the following steps:
Type Alt+h+l. This would open the following box of conditional formatting
Select the first option Highlight Cell Rules.
Select the Between option, which would open the following box:
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.
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) whereby entering the required values, you would get the desired results.
Article by