conditional format to mark increase from previous column

**rahmed** · 09-05-2013, 03:30 PM

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

**martindwilson** · 09-05-2013, 03:55 PM

you've lost me..you say in relation to goal then also in relation to each other what colour do you want the cells to be?
fill them in manually so we can see
the attached colours the same as your arrows

**rahmed** · 09-05-2013, 04:22 PM

I apologize for making the workspace so cluttered. I would like each month to show if it has exceeded the goal(color) that is set on the first column and if it has exceeded the previous month (arrow.) I've attached two files: the current sample and what I would like it to look like.

**martindwilson** · 09-06-2013, 07:22 AM

i cant see how you expect to get those arrows in the same cells
you could make another table referring to the original

**rahmed** · 09-09-2013, 11:49 AM

Thats exactly what I wanted to do, I just thought I had to use conditional formatting to do it.

Thank you

**arlu1201** · 09-11-2013, 07:13 AM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

conditional format to mark increase from previous column

LinkBack

Thread Tools

Rate This Thread

Display

conditional format to mark increase from previous column

Re: conditional format to mark increase from previous column

Re: conditional format to mark increase from previous column

Re: conditional format to mark increase from previous column

Re: conditional format to mark increase from previous column

Re: conditional format to mark increase from previous column

Thread Information

Users Browsing this Thread

Similar Threads

Incremental increase if previous cell is shaded

Conditional Formatting - comparing value to previous cell in column

How to make a one point conditional mark in a column

Conditional Format-is there a way to increase in Excel 2000?

[SOLVED] conditional cell format based on cell in same row, previous column

Bookmarks

Bookmarks

Posting Permissions