Greetings,
I am creating a spreadsheet, tracking my stock performance. I would like to have the cell color change automatically to red or green depending on whether the stock price went up or down. I am putting in an up or down arrow within the same cell as the stock price, using the Alt 24 or Alt 25 keys. Example: I have a cell whereby I enter an up arrow (↑), and then a number. If the cell has an up arrow, I'd like it to turn green. A down arrow - red. I hope this makes sense.
Appreciate any help.
Thank you.
I am creating a spreadsheet, tracking my stock performance. I would like to have the cell color change automatically to red or green depending on whether the stock price went up or down. I am putting in an up or down arrow within the same cell as the stock price, using the Alt 24 or Alt 25 keys. Example: I have a cell whereby I enter an up arrow (↑), and then a number. If the cell has an up arrow, I'd like it to turn green. A down arrow - red. I hope this makes sense.
Appreciate any help.
Thank you.