Conditional Formatting when cell value changes in a Column
Hello Everybody,
In my excel table, I have a Column to total Money transactions in the particular row.
I require two conditional formatting in this column
1. Whenever value in this row is greater than previous row, font color should be Green
2. Whenever value in this row is lesser than previous row, font color should be Red
I have searched a lot on this forum [and also in Google] and somehow am unable to get this to work.
Could you please help me with this?
Thanks in Advance...
Cheers
Sudan
P.S. I have no idea how to add VBA scripts to excel. Hence, can this formatting be done without any VBA scripts?
Last edited by sudan; 10-01-2011 at 09:52 AM.
See this workbook
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
Re: Conditional Formatting when cell value changes in a Column
Viola! Its done.
Thanks a lot Marcol.
P.S. One thing that I was missing while creating the Conditional Formatting is that I was not taking the Active Cell (and hence the active row) into consideration
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks