Hello! I'm new to the forum. Hopefully someone will be able to help me. I have a table set up that shows three years of data,and I want to compare the las two columns. Column C shows 2013 and Column D shows 2014. Column E is where I have entered the formula, SIGN(D5-C5), and applied conditional formatting using directional icon sets. I cannot figure out why some of the arrows are not pointing in the right direction. I.e. D10 and C10 are the same so the arrow should be yellow, but the green arrow is showing.
The spreadsheet is attached. Please Help!!
Bookmarks