Adding 40 to a number if the cell color is "blue"
Posted on 2014-03-03
Using Excel 2013 for Windows 2008.
I would appreciate a formula that would add 40 to numbers in a column if the COLOR of the column is a certain color. For example "Blue".
I assume I would need to add a column to receive the results of that formula.
So let's assume the original number is in b2 and the results should be put in C2