Conditional Formatting

  • Thread starter Thread starter Confused
  • Start date Start date
C

Confused

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.
 
Select the Whole Range of your data. Then go to format --> Conditional
Formatting --> formula1 is: =SUM($A1>500) and click format then select the
colours do u wish to highlight.

Here change the formula reference (column H) to your [Total] column reference.
 
Do you intend =SUM($A1>500) to give any different result from =$A1>500 ? If
so, what difference do you intend?
--
David Biddulph

TGV said:
Select the Whole Range of your data. Then go to format --> Conditional
Formatting --> formula1 is: =SUM($A1>500) 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 said:
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.
Click to expand...
Click to expand...
 
I highlighted the whole sheet.

I tried this =SUM($c1>500). 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 said:
Select the Whole Range of your data. Then go to format --> Conditional
Formatting --> formula1 is: =SUM($A1>500) 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 said:
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.
Click to expand...
Click to expand...
 
Back
Top