I’m creating a spreadsheet in Excel 2007 and I have 4 columns. Column A will only be either a green check mark or a red one depending on whether or not ANY text is entered into column D. How do I get column A to automatically display that RED or GREEN check mark when anything is type into column D. A RED checkmark if nothing is entered and a GREEN one if something is?
