Assuming your data is in A2:A20

B2: =IF(A2=4,A2,NA())
C2: =IF(A2<4,A2,NA())

copy B2:C2 down, add some labels to B1:C1, then chart B1:C20.

This will give you two series, one for the aboves, one for the rest.

Select each data series, right click, choose format, and set the colour as
required.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Excel Charts" <Excel wrote in message
...
No use of VBA or macros expected. It is believed to be Excel chart
feature.
Any ideas on how to change column colors (Red/Green) if value exceeds or
meets the preset goal.
Eg. if goal is 4% - anything at or above 4 should show green and under 4
should be red.