advanced conditional formatting in graph in excel

[vedantaher]

so there are  Date, Col3, col4 in my table (col3, col4 have same unit) and in line graph (Date on x axis and Col3,col4 unit on y axis) i want to give different color to the values of col3,4 on graph when there is weekend date (if there is Friday or Saturday) how should i go about it ? i can do that manually but would like to know if we can do it in other way

[#2]

@vedantaher Create a second series with only values for the weekend dates and format it as 'no line' and red markers. An example is attached.

[#3]

@vedantaher 

Assuming your weekend is Sat/Sun, you may need to adjust the formula

= IF(WEEKDAY(Date,2) > 5, Value, NA())