North Carolina is generally too far south to see much auroral activity, but in particularly strong magnetic storms, where the KP index exceeds 9, it may be possible to see a slight green hue to the northern sky.
The graphs below show the current measurements of geomagnetic activity from USGS Geomagnetic Observatories in the mid latitudes. The Fredericksburg Station (2nd graph below) is the best indicator of when we might some evidence of auroras in central North Carolina and southern Virginia. For more information see the NOAA Space Weather Prediction Center.
Other locations in North America have a lower Kp threshold for auroras to be visible.