Conditional Formatting
 

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.

Conditional Formatting
 

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.

Conditional Formatting
 

Do you intend =SUM($A1500) to give any different result from =$A1500 ? If
so, what difference do you intend?
--
David Biddulph

"TGV" wrote in message
...
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.

Conditional Formatting
 

I highlighted the whole sheet.

I tried this =SUM($c1500). C is where the data is. It turns some rows red
but not just ones where the values in C were greater than 500.

I didn't see a way to do this part "Here change the formula reference
(column H) to your [Total] column reference"

What am I missing please!

"TGV" wrote:

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.