Hi, I have setup a formula that is based on other rows to return a certain value, in effect in cell AW4 it's something like =IF(AM4="",Average,AM4) with Average being a named range. Cell AW5 has the same formula except the values for average move down one; I'm covering range AW4:BE94 with this formula. It all works great but what I want to do is conditionally format the cells in range AW4:BE94 so that if the value in those cells is equal to the average value in its corresponding row then it will be highlighted, if it something other than the average then it's not highlighted. I'm kind of stumped as while it's easy to highlight based on one value this is dynamic as the Average figure is different in each row as you move down the sheet. I've tried putting in different formulas but none seem to work. Any help would be appreciated.