ayi You can create conditional color formatting on line charts by first making a bar chart. Make a bar chart, set the column colors to some conditional rule, then switch to a line chart. Done.