Dynamic changes to the cells based on conditions
-
QUESTION: Greetings!!! How to Change background color of a cell based on the value of previous cell For Example If value of cell is nagative, the color of adjucent cell must be Red, If value of cell is Zero, the color of adjucent cell must be Yellow, If value of cell is Positive, the color of adjucent cell must be Green, Similarly, Can we insert the Arrow like art based on the value of previous cell. ANSWER: On2007 you can do plenty wonderful things, including adding those arrows, bars, etc, and is very user friendly However, you can¡¯t do that on previous versions to set up the conditional formatting you have to: e.g.: cell A1, needs to be either red, yellow or green based on value of B2 step into cell A1, then go to Format > conditional formatting Choose formula is: =B1 0 for green then you can copy that conditional formatting using the drag which is the bottom right corner of the cell (but I am sure you already know this) it's important though, that you use relative references like B1, not absolute like $B$1 ---------- FOLLOW-UP ---------- QUESTION: Thank you for your answer.... I planned to create simple macro in excel, to automatically change the direction and color of the arrow an shown in the image. If it is not possible in Excel 2007, Please suggest the version in which we can get this feasibility, or kindly provide if there are any other options to get that. I have nearly 200 Rows to change the directions and colors of Arrows I hope my problem will solved with your support.
-
Answer:
Sorry, Maybe I confused myself What I meant is IT IS possible in 2007, the conditional formatting menu on it has thousands of possibilities, from arrows, traffic lights, bars and others, just go to conditional formating. You can follow through this linkhttp://msdn.microsoft.com/en-us/library/bb286672(office.11).aspx
Miningco.com Visit the source
Related Q & A:
- How to remove spaces between cells?Best solution by Stack Overflow
- How do cells maintain homeostasis?Best solution by Yahoo! Answers
- What is the difference between cytokinesis in animal cells and cytokinesis in plant cells?Best solution by Yahoo! Answers
- Why do cells come together?Best solution by unitedstreaming.com
- What are embryonic stem cells?Best solution by stemcells.nih.gov
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.