In VBScript, I'd like to make it so that if a selected record meets a certain criteria, then that entire record row will change color. There's so many elements of the table though, that I can't seem to make it happen. PivotTable.??? controls the cell colors? Anyone do this before? Thanks.