Jun 14, 2016 #1 wanzek Technical User Mar 8, 2010 58 US I am struggling coming up with a way to highlight certain cells in a Matrix report. I want to highlight the cell for the corresponding work order if the Date scheduled = the column date. Any ideas? Thanks!
I am struggling coming up with a way to highlight certain cells in a Matrix report. I want to highlight the cell for the corresponding work order if the Date scheduled = the column date. Any ideas? Thanks!
Jun 15, 2016 Thread starter #2 wanzek Technical User Mar 8, 2010 58 US I have tried the following and the results are not correct: =iif(Fields!DateSched.Value=Fields!Date.Value,"Red","Transparent") Work Order # 2181 should only have the corresponding cell under 1/4/2015 highlighted Fields!Date.Value - is the date field that runs across the top of the page in the matric Upvote 0 Downvote
I have tried the following and the results are not correct: =iif(Fields!DateSched.Value=Fields!Date.Value,"Red","Transparent") Work Order # 2181 should only have the corresponding cell under 1/4/2015 highlighted Fields!Date.Value - is the date field that runs across the top of the page in the matric