PC Review


Reply
Thread Tools Rate Thread

Comparing Values from One Cell to Another

 
 
EriccW
Guest
Posts: n/a
 
      7th Jan 2009
I would like to compare the values of a cell to the cell before and after it.
The qualifier is I need to see the difference as a color based on whether the
value is more than 9 over or less than the previous cell:
i.e.
Cell Value Result
C1 18 no change
C2 8 cell color is yellow
C3 16 cell color is green

I know this requires a Macro, but I'm not sure where to start in creating
this.
 
Reply With Quote
 
 
 
 
Corey
Guest
Posts: n/a
 
      7th Jan 2009
Conditonal Formatting will do that easily for you.

>Format>Conditional Formatting


From the toolbar menu


Corey....

"EriccW" <(E-Mail Removed)> wrote in message
news:AA157B1D-6E2C-49C5-A422-(E-Mail Removed)...
>I would like to compare the values of a cell to the cell before and after
>it.
> The qualifier is I need to see the difference as a color based on whether
> the
> value is more than 9 over or less than the previous cell:
> i.e.
> Cell Value Result
> C1 18 no change
> C2 8 cell color is yellow
> C3 16 cell color is green
>
> I know this requires a Macro, but I'm not sure where to start in creating
> this.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing values in a cell and looping Michael_Randall Microsoft Excel Programming 1 3rd Feb 2010 06:29 PM
Comparing a range of values against a cell =?Utf-8?B?TWVtZW50bw==?= Microsoft Excel Programming 2 21st Jun 2007 04:09 PM
Question about comparing 2 cell values mCassidy Microsoft Excel Misc 3 16th May 2007 09:37 PM
Comparing cell values Touk Microsoft Excel Programming 3 29th Sep 2004 11:04 AM
Comparing values with a cell Estherl Microsoft Excel Worksheet Functions 2 11th Jun 2004 07:24 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:17 AM.