PDA

View Full Version : Using "IF" in conditional formatting



Goose93
01-09-2020, 04:03 PM
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.

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

Scott Huish
01-21-2020, 11:43 PM
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