Hi,
From the screenshot below, I'd like to highlight the last row red if the value is greater the average of all the rows (i.e. Analysis Dates) above it. Obviously some cells will be red and some wont... the formula will have to be column specific, but I am not sure how to accomplish this. Any suggestions? I just found out how to color code entire rows, but not specific cells.
Thank you,
Calvin
