+ 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
    125

    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
    125

    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
    23,618

    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.

    Forum Rules Updated September 2018. Please read them by clicking here.

  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
    23,618

    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
    125

    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
    23,618

    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
    125

    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