Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |