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.
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
Bookmarks