I want to be able to have an up or down arrow show in a cell next to another cell to show whether a new value in a that cell is greater or less than the previous value in that cell. Can anyone help please?
you will need code if you are gong to ovewrite the cell
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks, martindwilson. I realise that coding will be necessary but how does one do it? I can't find any examples in the links you provided.
You could use conditional formatting fo this. If you set it up right, it will put an up, side or down arrow inthe cell that contains the value.
Little hard to explain, but here goes...
set new CF rule - "format based on value"
"edit rule description" - format set = "icon"
"icon style" = 3-arrow
"type" = "number"
"value" = the number you want to compare to
Play with this, I got it to work on a simple comparison, hope it works for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks