I am trying to find out how to display information over multiple cells. By
this i mean i have a formula (not sure if i should use another) (=IF(A6="Wet
Navy") that when Wet Navy is written in A6 the "if" function will execute. i
also have an are with information on it (15Cx37R) that is far off to the
side. I am trying to find a formula or function somewhere to have all the
cells in the 15x37 to show in another 15x37 area when the "if" condition is
met. Does anyone have any ideas on how to accomplish this?