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

Secant

New member
Joined
May 14, 2014
Messages
31
Reaction score
0
Points
0
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?
 
Use conditional formatting, and test for that value.
 
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.
 
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.
 
Bob, I acknowledge your help....Thank you for replying to me.
 
Back
Top