I need to have excel 2007 display "N/A" in cells C44:V44 if the specified conditions are not met; like in this formula.
=IF(OR(C$4="a",C$4="b",C$4="c",C$4="d",C$4="e",C$4="f",C$4="g",C$4="h",C$4="i",C$4="j",C$4="k"),C44="",C44="N/A")
But I need it to not be in the cell array so I can input a date (manually) in the blank cell without loosing the "code", and I need it to apply to all C44 rows across the workbook.
I do not know much about VBA so please be as detailed as possible.
Thank you.
Bookmarks