Hello!
Anyone know of a formula where I can take a number from an adjacent cell and have it autofill a word?
I have the numbers .4, .6, .8, 1, 1.2, 1.4, 1.6, 1.8 and 2. For each of these that appear in collumn F, I want it to autofill a correspoonding text (#E6FFE6, #CCFFCC, #99FF99, #66FF66, #00FF00, #00B200, #008000, #004C00, #001A00) into collumn G.
Any suggestions??
Thanks!
Bookmarks