Forum Discussion
Joshua Armstrong
Nov 06, 2018Copper Contributor
Conditional formatting cells by percentages
I am using office 2016. I have a document that I update daily. I am trying to have the top cell format red if there is a 20% discrepancy between the numbers. I add a new line every da...
erol sinan zorlu
Nov 06, 2018Iron Contributor
write this formula to Conditonal Formating->New Rule-->Use a formula to determine which cells to format
=ABS/($B2-$H2)/$B2)>0,2
and below line to Applies to:
=$A$1:$M$1
if you want to have the same rule applied in more rows change the row number in the last formula.รง
- Joshua ArmstrongNov 06, 2018Copper Contributor
Got this error listed. I changed the corresponding cells accordingly.
- erol sinan zorluNov 06, 2018Iron Contributor
Sorry there was a syntax error. It should have been
=ABS(($B2-$H2)/$B2)>0,2
- Joshua ArmstrongNov 06, 2018Copper Contributor
Thanks. Can you explain how the formula works so i can see how the calculation is processed?
I'm still getting the same error code.
If it helps to clarify, with the last screenshot I loaded. I wanted the value of B4 and B5 compared, and if B4 is more or less than 20% of B5, it would highlight.