View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fletch Fletch is offline
external usenet poster
 
Posts: 6
Default Conditional Format based on Other Cells

The variance limit input area is for changes greater than amount input In
this case anything greater than $10,000 and 10%. We are trying to simplify
the review of our salary changes to highlight any changes that fall outside a
normal expected range (both increases and decreases)

If someone were to input variance amounts of $10,000 and 10% in my input
area, I want the cells in my example to turn yellow. I would also want the
cells highlighted if the salary amounts in my example were $50,000 and
$25,000 with variances of -$25,000 and -50%