Create line charts with conditional formatting

[Marco1975]

Hi. I would like to create a line chart with conditional formatting from a table with two data : number documents and working months . Conditional formatting regards the current month that must change color automatically ( default red and yellow current month ) . Sorry for my English but I'm Italian . I asked for help in this forum because in Italian forum nobody has been able to solve the problem . I attach the excel file containing the original graph and a graph with the end result that I would have. Thanks for your help.

 

[Luke M]

Hi, and welcome to the forum Marco!

You will need to create a second series to act as the "special" line, and we can format it as desired. I setup a basic formula rule to highlight the item in current month.

 

[Marco1975]

Hi, and welcome to the forum Marco!

You will need to create a second series to act as the "special" line, and we can format it as desired. I setup a basic formula rule to highlight the item in current month.

Great you solved the problem in a short time. Thank you very much Luke!!!!