Results 1 to 2 of 2
  1. #1
    Naustvik is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    1

    Format cells containing spesific text

    Hi!

    In a report I've got some cells that should have different background-colors depending og their content. I have done this with conditional formatting, but now I would like to only use a part of the text as condition for the formatting.



    Excample:
    If the condition is "house", I would like both "house", "boathouse" and "houses" to be formatted.

    Can anyone help me with this?

    Please ask me for clarification.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Try an expression of:

    [FieldName] Like "*house*"
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Viewing content of long text cells
    By mglevicky in forum Access
    Replies: 3
    Last Post: 01-23-2017, 09:38 AM
  2. Replies: 3
    Last Post: 12-30-2016, 10:27 AM
  3. Replies: 45
    Last Post: 07-27-2015, 01:17 PM
  4. Replies: 2
    Last Post: 04-14-2015, 09:37 AM
  5. Replies: 9
    Last Post: 03-13-2014, 07:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums