OK. Thanks.
Is the following possible - the cell showsthe difference in numerical terms
but I also add in a formula that says that if the difference is more than
10%, then the cell is colored red.
Basically, I want to see the difference in numerical terms but would like to
get some indication where the percentage difference is more than 10%.
Thanks!
"Fredrik Wahlgren" wrote:
"Chandni" wrote in message
...
I want to show the difference between two values both in numerical terms
and
percentage terms in a single cell preferably. I know I can create two
separate columns but that will lead to a monster sheet that I am trying to
avoid.
Is there a function in Excel where you can add two (or more) values to the
same cell and when a person scrolls over the cell - he/she has the option
to
choose which value to view - or something like that...
I think you have to stick with the two column approach. However, you can
make a macro that will hide one column and make the other visible and vice
versa.
/Fredrik
|