Excel Formatting Tip 6 - Highlight Cells Greater Than or Less Than a Certain Value in Excel 2007

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

Use Conditional Formatting in Excel 2007 in order to quickly and efficiently format values in a list that are greater than a certain value or less than a certain value. This method does not remove or hide any rows like the filtering data method and it is quick and easy to use. This tutorial also shows you how to change the format of the cells that are greater than or less than a certain value and how to completely remove or edit the conditional formatting options for the selected cells in the spreadsheet.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• conditional formatting
• highlight cells
• display cells greater than
• format cells in excel

[kenable187]

hi, i work for a company where i need to track changes in inventory quantities. some of our clients dont carry our full line of products, making it very difficult to track changes in inventory unless you do it the old fashion way. (comparing each individual product on the list) I know how use the "IF" function to compare one column of numbers to another, but the problem is that one column may contain inventory items the other list doesn't which throws off the formula..any suggestions?

[C4CNinja]

Thanks really helped.

[ExcelisHell]

@okaygojay no problem, glad to help!