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?
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Use conditional formatting, and test for that value.
 

Secant

New member
Joined
May 14, 2014
Messages
31
Reaction score
0
Points
0
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.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
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.
 

Secant

New member
Joined
May 14, 2014
Messages
31
Reaction score
0
Points
0
Bob, I acknowledge your help....Thank you for replying to me.
 
Top