Results 1 to 8 of 8

Thread: Conditional Formatting and other Dilemmas

  1. #1

    Conditional Formatting and other Dilemmas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I have the following dilemmas:
    1. If cells "A3-A1000" value > cells "B3-B1000" value would like to display "Incline" in cells "C3-C1000" and opposite if < to show "Decline"?
    2. One new tab added each corresponding month (Jan, Feb, Mar etc) with new data. First tab ("Annual") has a sum of all months data. I would like in tab "Annual" to have a new column that will highlight the increase or decrease from the previous month numbers with the above conditional formatting showing an arrow up/down or word "Incline"/"Decline" instead of value.
    Thank You so much for input.

  2. #2
    In C3

    =IF(A3>B3,"Incline",IF(A3<B3,"Decline","Equal"))

    and copy down

  3. #3
    Thank You so much Bob. One more question. How can I have on the "Annual" sheet this formula adapting automatically so each month will compare "Annual" with last month, basically adapting your formula so "A3" is last month (each month data are on different sheet) with "B3" (the Annual total to date - Sum of 12 months). Basically how can I have A3 jumping each month to "last month". Is there any formula that can be adapted to this. Thanks so much for any input.

  4. #4
    =IF(INDIRECT(TEXT(EOMONTH(TODAY(),-1),"mmmm")&"!A3")>B3,"Incline",IF(INDIRECT(TEXT(EOMONTH(TODAY(),-1),"mmmm")&"!A3")<B3,"Decline","Equal"))

  5. #5
    Thanks for your help. Did I told you I am kind of newbie Anyway do I have to change something in the formula (mmmm) or anything else as it is not working with copy/paste. Thanks.

  6. #6

    Update

    Quote Originally Posted by Bob Phillips View Post
    =IF(INDIRECT(TEXT(EOMONTH(TODAY(),-1),"mmmm")&"!A3")>B3,"Incline",IF(INDIRECT(TEXT(EOMONTH(TODAY(),-1),"mmmm")&"!A3")<B3,"Decline","Equal"))
    Hi Bob. I attached the spreadsheet with a little explanation on the annual tab. Thanks so much
    Attached Files Attached Files

  7. #7
    Anyone have any ideas?

  8. #8
    Surely, the sum of all months will always be greater than the current month value, so it will always be Incline won't it?

Posting Permissions

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