Tuesday 15 March 2016

How to Indicate Greater Than or Less Than Values in MS Excel (Excel 2007-2016)

how to highlight data value in excel,how to indicate duplicate entry,how to highlight greater than value,how to highlight less than value,how to indicate greater value in excel,conditional formatting,color highlights,data bars,icon set,how to indicate,find greater value,find less than value,color indicator,color highlight,find value,find data,duplicate,wrong,greater,less,excel tips How to Indicate or Highlight Greater Than or Less Than Values in MS Excel (Excel 2007-2016)While working in Microsoft Excel with huge data entry, its really hard to find out greater than or less than values, so in this post I will be showing how to indicate or highlight greater than or less than values by using conditional formatting in excel, this method will work all the version of MS excel like 2007, 2010, 2013 and 2016.

1.       Select entire data value cells

2.       Click on “Home” and click on “Conditional Formatting”
How to Indicate or Highlight Greater Than or Less Than Values in MS Excel (Excel 2007-2016)

3.       You have lot of option to highlight or indicate values like “Data Bars” “Color scales” or “Icon Sets”, choose anyone and apply.

4.       If you want to apply this to other cells, select one cell and drag down or left with mouse.

Watch video tutorial… Please like, share & subscribe

How to Copy Multiple Texts & Objects and Paste Them at Once

  How to Copy Multiple Texts & Objects and Paste Them at Once Copying and pasting is a common task, but the traditional clipboard can ...