Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Highlighting Cells in a Matrix report

Status
Not open for further replies.

wanzek

Technical User
Mar 8, 2010
58
US
I am struggling coming up with a way to highlight certain cells in a Matrix report.
Work_Order_mwyxsk.jpg


I want to highlight the cell for the corresponding work order if the Date scheduled = the column date. Any ideas?

Thanks!
 
I have tried the following and the results are not correct:

=iif(Fields!DateSched.Value=Fields!Date.Value,"Red","Transparent")

Work_Order_1_wut0sr.jpg


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

Work_Order_2_xdncvv.jpg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top