Hi,
I have a cell A1 that contains a percentage. Either negative, zero or positive. In cell B1 I want to show a green icon if A1 is above zero, yellow if it is zero, and red if below zero. Seems easy but I can't figure it out.
Hi,
I have a cell A1 that contains a percentage. Either negative, zero or positive. In cell B1 I want to show a green icon if A1 is above zero, yellow if it is zero, and red if below zero. Seems easy but I can't figure it out.
Figured it out by doing this;
Capture.JPG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks