Jan 02 2022 09:49 AM
Jan 02 2022 09:57 AM
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
Jan 02 2022 09:35 PM - edited Jan 02 2022 09:45 PM
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'