+ Reply to Thread
Results 1 to 7 of 7

Conditional Formatting based on either a word, a letter or a number

  1. #1
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    117

    Conditional Formatting based on either a word, a letter or a number

    Dear Forum.

    Wondering if someone could help me out and let me know how to do the following. Please see attached basic file.

    I want cells I10:I19 to be such that if it is "None", it will fill grey, if it is a letter (A thru Z), it will be yellow, if it is a number it will be green.

    Thank you for any help you can provide!
    Last edited by Cidona; 12-11-2017 at 11:12 AM. Reason: Marked as solved

  2. #2
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    117

    Re: Conditional Formatting based on either a word, a letter or a number

    Hi came back to double check I had uploaded the file. I hadn't and I seem to be having issue getting it uploaded. Here is a picture as that seems to inset ok.

    Conditional Formatting Picture.jpg

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    22,832

    Re: Conditional Formatting based on either a word, a letter or a number

    Hi,

    The workbook was missing but in its absence in I10 copied to I19

    Greeen
    =ISNUMBER(I10)
    Grey
    =I10="None"
    Yellow
    =AND(I10<>"None",ISTEXT(I10))
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    22,832

    Re: Conditional Formatting based on either a word, a letter or a number

    Quote Originally Posted by Cidona View Post
    Hi came back to double check I had uploaded the file. I hadn't and I seem to be having issue getting it uploaded. Here is a picture as that seems to inset ok.
    Unfortunately the paperclip 'attach' (sic) icon doesn't work .

    If you click on the Go Advanced button you'll find an area underneath the post panel called 'Manage Attachments' which will work.

  5. #5
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    117

    Re: Conditional Formatting based on either a word, a letter or a number

    Thank you for your response Richard. Sorry just getting back now.

    I'm afraid I don't quite understand your solution. I have attached the file via the manage attachments method you mentioned (Thank you!). Could you copy and paste into that workbook so I can see?

    Thank you again.
    Attached Files Attached Files

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    22,832

    Re: Conditional Formatting based on either a word, a letter or a number

    Hi,

    See attached
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    117

    Re: Conditional Formatting based on either a word, a letter or a number

    That is a thing of beauty Richard. Thank you very much!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1