Forum Discussion
vedantaher
Sep 11, 2023Copper Contributor
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 ...
PeterBartholomew1
Sep 11, 2023Silver Contributor
Assuming your weekend is Sat/Sun, you may need to adjust the formula
= IF(WEEKDAY(Date,2) > 5, Value, NA())