Results 1 to 6 of 6

conditional format to mark increase from previous column

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    3

    conditional format to mark increase from previous column

    Hello,

    I've been learning to use excel through the aide of forums and I've stumbled across a problem and I just can't find the answer. I have a goal set for the year. With conditional formatting, each month will be set to either red or yellow based on where it stands in relation to the goal. I would also like to show an increase or decrease in productivity for each month. I tried to use conditional formatting with the formula: =IF(C2=D2, "", IF(C2<D2,"↗","↘")). The formula works on its own without the conditional formatting so I am not sure what I am doing wrong. I've attached a sample with all the conditional formatting and formulas in place.

    Thanks in advance,
    Ragbe
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Incremental increase if previous cell is shaded
    By Nicely in forum Excel General
    Replies: 0
    Last Post: 03-01-2012, 10:36 PM
  2. Replies: 3
    Last Post: 04-06-2011, 01:15 PM
  3. How to make a one point conditional mark in a column
    By tomjoe in forum Excel General
    Replies: 2
    Last Post: 01-08-2011, 06:29 PM
  4. Conditional Format-is there a way to increase in Excel 2000?
    By Martindelica in forum Excel General
    Replies: 3
    Last Post: 01-27-2008, 04:03 PM
  5. [SOLVED] conditional cell format based on cell in same row, previous column
    By tamiluchi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-03-2006, 11:15 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1