Select the Whole Range of your data. Then go to format -- Conditional
Formatting -- formula1 is: =SUM($A1500) and click format then select the
colours do u wish to highlight.

Here change the formula reference (column H) to your [Total] column reference.

--
If this post helps, pls click Yes
---------------
TGV


"Confused" wrote:

I'm trying to accomplish this: If any value in [total] is 500 then I want
to highlight all of the company names in the [customer] field as red. Or
even highlight the entire rows meeting this criteria. Any help greatly
appreciated.