Results 1 to 5 of 5

Thread: How do I return a red cell if N or S is entered?

  1. #1

    How do I return a red cell if N or S is entered?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    In cell F13, I want to be able to enter the capital letter N or S. If any other entry apart from N or S is entered, I want the same cell, F13, to return as a red cell.....How do I do this?

  2. #2
    Use conditional formatting, and test for that value.

  3. #3
    Bob, thanks for your reply....your reply didn't answer my question completely as I was left wondering what to do after I got into the conditional formatting part, which, through trial and error, and guessing, eventually led me to what I wanted to achieve....
    Thanks for your reply.

  4. #4
    I didn't intend to answer your question completely, My aim was to point you n the right direction, but to get you to learn how to use this function.

  5. #5
    Bob, I acknowledge your help....Thank you for replying to me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •