Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting?
Is there any way to use conditional formating onto auto shapes from excel
draw. I need to have a triangle shaped object, and it's parts should be able to change color depending on a list of average values. If someone understands what I mean by this and could give me an answer, it would be great and highly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting?
I don't believe you can use conditional formatting, but you can use
code similar to below in the Worksheet_Change event. Modify to suite: If WorksheetFunction.Average(Range("E8:G8")) = 50 Then ActiveSheet.Shapes("Oval 1") _ .Fill.ForeColor.SchemeColor = 37 Else ActiveSheet.Shapes("Oval 1") _ .Fill.ForeColor.SchemeColor = 65 End If T. Lindholm wrote: Is there any way to use conditional formating onto auto shapes from excel draw. I need to have a triangle shaped object, and it's parts should be able to change color depending on a list of average values. If someone understands what I mean by this and could give me an answer, it would be great and highly appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting?
Ok I got it to work, thanks a bunch! By the way if I need multiple criterias
to the code how should I type them? "JW" wrote: I don't believe you can use conditional formatting, but you can use code similar to below in the Worksheet_Change event. Modify to suite: If WorksheetFunction.Average(Range("E8:G8")) = 50 Then ActiveSheet.Shapes("Oval 1") _ .Fill.ForeColor.SchemeColor = 37 Else ActiveSheet.Shapes("Oval 1") _ .Fill.ForeColor.SchemeColor = 65 End If T. Lindholm wrote: Is there any way to use conditional formating onto auto shapes from excel draw. I need to have a triangle shaped object, and it's parts should be able to change color depending on a list of average values. If someone understands what I mean by this and could give me an answer, it would be great and highly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |