Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2002
    Thanked 0 Times in 0 Posts

    CONDITIONS (2000)

    I have two cells - one will contain either an "E" or an "I". I want the formatting of the second cell to be negative if the first cell is an "E" or positive if it is an "I" in the first cell. I want this to happen BEFORE anything is typed in the second cell - so when something is typed in the second cell it will automatically be a negative or positive number depending on the first cell.

    Can anyone help.

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Dallas plus 20 miles or so, Texas, USA
    Thanked 0 Times in 0 Posts

    Re: CONDITIONS (2000)

    Two things you might consider:

    1 - Using a third column or row to calculate the value you need i.e. adjust the value in the entry cell based on the value in the cell containing "E" or "I" such as in C1 =If(a1="E",-b1,+b1) or some such.

    2 - A worksheet event to change the value in the target cell depending on the cell containing "E" or "I"

Posting Permissions

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