Conditional charts are done by using multiple data series, formatted for each condition.
The use formula to determine whether the data point for each series is the data value or #N/A