I am currently trying to develop a dashboard which monitors the # number of errors (rows) sent from each asset for each error type (columns). The problem is, the user has requested to be able to highlight the # of repeat days an error has occured. For example, if he selects 5, the dashboard should highlight the bars that has been sending errors consecutively for equal or more than 5 days (C1, d58 would be an example).
I hope I explained clearly, please let me know.
Post a packaged workbook and I'm sure someone will have a go at it for you.