Using "IF" in conditional formatting

I'm unsure whether this is possible but I'm wanting to conditionally format the attached data set so that the values in Row 7 will be highlighted "if (row7value-row6value)/row7value≥±0.05". Any help or guidance would be greatly appreciated.

see attached:
Select cells C5:BO8, go into conditional formatting, Use a formula to… and use:
=(ABS(C5-C4)/C5)>=0.05

Quote:

---

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