Consulting

Results 1 to 2 of 2

Thread: Solved: Formula for Conditional Formatting

  1. 01-12-2009, 04:55 AM #1
    BENSON
    BENSON is offline
    VBAX Contributor
    Joined
    Dec 2006
    Posts
    193
    Location

    Solved: Formula for Conditional Formatting

    What is the formula to have in conditional formatting if a projected sales amount is within 10% either way +- of an actual sales amount

    THANKS
    Reply With Quote Reply With Quote
  2. 01-12-2009, 05:10 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Try

    =ABS(1-actual_amount/projected_amount)<=10%
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules