Hello
Hopefuly someone will be able to help. If I had a value in one cell that is a forecast figure, say this is in A1, in A2 would then be an actual.
I want to be able to apply some conditional formatting that will colour cell A2 green if it's within 10% either way of the value in A1 or red if more than 10% out.
Thanks very much
Dan
Hi,
For the green format,
=(ABS(A$2-A$1)/A$1)<=0.1
For the red format
=(ABS(A$2-A$1)/A$1)>0.1
Please note that if you're going to use this for the whole row, the $ signs are important.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
conditional format
condition 1 formula is
=AND(B1<=A1+A1*10%,B1>=A1-A1*10%) green
condition 2 formula is
=OR(B1>A1+A1*10%,B1<A1-A1*10%) red
Thanks very much guys. Works great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks