+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting based on part content of a cell

  1. #1
    Valued Forum Contributor
    Join Date
    06-30-2005
    Location
    Verwood, Dorset, England
    MS-Off Ver
    Excel 2000
    Posts
    479

    Conditional Formatting based on part content of a cell

    I am using excel 2000

    I want to apply conditional formatting to a range of cells if they contain (V) as part of the cell contents

    The cells will generally look like this : 09.00-6 (V) or 9-5.30 (V)

    I want to shade any cell if part of the contents of that cell is (V)

    Thanks in advance for your help
    Last edited by Paul Sheppard; 09-10-2009 at 01:08 PM.
    Paul

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Conditional Formatting based on part content of a cell

    you can perhaps use a Formula based approach of:

    Please Login or Register  to view this content.
    (if you wish to be case insensitive revert to SEARCH rather than FIND - note: I don't have XL2000 so I can't recall off hand what's available and what is not I'm afraid...)

  3. #3
    Valued Forum Contributor
    Join Date
    06-30-2005
    Location
    Verwood, Dorset, England
    MS-Off Ver
    Excel 2000
    Posts
    479

    Re: Conditional Formatting based on part content of a cell

    Thanks DonkeyOte that worked

+ 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