Automatically Highlight Max Value in a Data Table Using Conditional Formatting/xl maza

When you are looking at a large list of numerical data, it’s useful to find maximums and minimums. You can always sort the list to find the largest totals, but if you can’t modify the data (or want to sort by some other rule, like alphabetical), you might need another way to find the max or min. Conditional Formatting in Excel lets you set rules for highlighting values just like you would when using IF statements. Let’s walk through an example using quarterly sales data…

[zubairtahir]

Sir main chata hun ke sales person ke name ki alag alag sheet banun or Chahta hun ke mainsheet main agr oss ka name main Jo Jo data hai wo oss ke name ki sheet main add ho jai or agr Wohi name wapas aai oss main Jo data likhe wo bhi oss ke name ki sheets main add hota rahe