Need urgent help

Occasional Visitor
I have a Excel table data which contains Product Name, Product Code, date of sale and amount of sale. Amount of sale changes as per negotiation for each sale for a product. I want to highlight all individual sales when total sale in a product crosses threshold of $10 million.
2 Replies


You may apply conditional formatting rule with formula like

=SUMIFS(<Cost column>, <Product Code column>, <Product Code in first cell of the range using relative references>) > 10000000

Select the Amount of Sale column and apply:
Conditional Formatting --> Highlight Cells Rules --> Greater Than

Set your condition and the Highlight Format.


If you want to highlight the row, go to conditional formatting, select new rule, select the table you want to apply on and define the formula for the condition, something like:

$D2>'your value'