+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting

  1. #1
    Registered User
    Join Date
    06-06-2018
    Location
    Aus
    MS-Off Ver
    2013
    Posts
    3

    Conditional Formatting

    Hello all
    I need a method to conditionally format (fill with colour) a cell if another cell contains any text, not a specific text.
    Help would be greatly appreciated!

  2. #2
    Banned User!
    Join Date
    01-26-2019
    Location
    United States
    MS-Off Ver
    2010
    Posts
    32

    Re: Conditional Formatting

    Maybe like this:

    =A1<>""

  3. #3
    Registered User
    Join Date
    06-06-2018
    Location
    Aus
    MS-Off Ver
    2013
    Posts
    3
    Quote Originally Posted by billgyrotech1 View Post
    Maybe like this:

    =A1<>""
    Thanks Billy, I will try soon and let you know!

  4. #4
    Registered User
    Join Date
    06-06-2018
    Location
    Aus
    MS-Off Ver
    2013
    Posts
    3
    Quote Originally Posted by billgyrotech1 View Post
    Maybe like this:

    =A1<>""
    Yep it worked! Thanks a lot!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    23,044

    Re: Conditional Formatting

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

+ 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