Thanks Michael!!!!

"Michael" wrote:

> Hi JJ
> Try this for more than or less than 5%
>
> =IF(D2>(C2*1.05),"Flag",IF(D2<(C2*0.95),"Flag",""))
>
> Change the "Flag" text to suit yourself.
>
> HTH
> Michael
>
> "jj" wrote:
>
> > I'm struggling to create an exception report.
> > I need to flag an empty cell if the adjacent cell varies more than 5% of
> > another cell.
> > Example:
> > C2 is $100
> > D2 is $300
> > I need E2 to post a * indicating D2 is more than 5% of C2
> > Any help would be appreciated.