Forum Discussion
advanced conditional formatting in graph in excel
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 Replies
Assuming your weekend is Sat/Sun, you may need to adjust the formula
= IF(WEEKDAY(Date,2) > 5, Value, NA())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.
