Originally Posted by p45cal see attached: Select cells C5:BO8, go into conditional formatting, Use a formula to… and use: =(ABS(C5-C4)/C5)>=0.05 That doesn't accommodate for the 2 different rows that are supposed to be in the formula or that it is specifically row 7 Select C7:BO7 and use the following conditional formatting formula: =(ABS(C7-C6)/C7)>=0.05
Forum Rules
Bookmarks