• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
WittySparks Logo White

WittySparks

Ignite Your Thoughts

  • Topics
  • Reviews
  • Services
  • Newsletter
WittySparks / Technology / Software / How to find values in a range in a sheet? – MS Excel 2007 Tips

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

Updated: January 29, 2022 by Kartik Subramaniam • < 1 min read

Conditional Formatting Range - MS EXCEL 2007

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.

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) whereby entering the required values, you would get the desired results.

Related Topics

  • QuillBot Review: Is this “The Ideal Writing Tool” You Are Looking For?
  • AppSumo Review? Contains a List of the Best AppSumo Deals!
  • Revolutionizing Artistry: The Mesmerizing Power of AI Portrait Generator
  • CleanShot X for MacBook: A Comprehensive Hands-On Review

Topic: Software

Profile picture for Kartik Subramaniam Article by

Kartik Subramaniam

A dreamer of sorts & a Creative writer, passionate about reading diverse stuff.

View all posts by Kartik Subramaniam

Primary Sidebar

Featured Productivity Software

Notion logo
Notion

Notion Workspace can help you stay organized and take your productivity to the next level. Use Skillshare coupon code WITTYSPARKSFREE to watch the Notion Masterclass by Ali Abdaal for FREE.

Take Free Notion Masterclass

The Best Digital Marketing Tool

Semrush logo
Semrush

Semrush helps grow your business on your terms and gets to the top with 55+ marketing tools in 1. Get a flat 40% discount on Guru plan or Try 14-day PRO Trial.

Try Semrush for FREE

Footer

Explore Topics

  • Technology
  • Business
  • Marketing
  • SEO
  • View All Topics

Sponsors

Partnered with FreePik to use the licensed images.

turn to dhgate for smartphone

Affiliate Link Disclosure

If you make a purchase from links, we will receive a small commission. See our Affiliate Disclosure.

Follow Us

  • Facebook
  • Twitter
  • Pinterest
  • LinkedIn
  • Instagram
  • YouTube
  • RSS
  • Mastodon

Copyright © 2023 WittySparks - All rights reserved.
Hosted on Rocket.net

  • About Us
  • Contact Us
  • Privacy Policy