Conditional Formatting

[kberry97]

First post, hope i'm doing it right.
I have a cell that I need highlighted yellow if it contains numbers or special characters and green if it only contains letters. I have tried everything I can think of and find elsewhere. Any ideas? Thanks.

[protonLeah]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[kvsrinivasamurthy]

pl see attached file. A4 is formatted .

[kberry97]

Thanks for the reply, kvsrinivasamurthy. It seems like you have it set up to turn green if it contains any letters at all. I need it to turn yellow if it contains any numbers or special characters at all and green if it is only letters. Is that possible?

[kvsrinivasamurthy]

If it only letters it turns green.If it is numbers or special character turns yellow.
Gives some examples Input and required colour.