+ Reply to Thread
Results 1 to 3 of 3

conditional format cells based on first letter and other?

  1. 03-12-2021, 03:15 PM #1
    Excl3454
    Excl3454 is offline
    Registered User
    Join Date
    01-29-2021
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    93

    conditional format cells based on first letter and other?

    conditional format cells based on first letter/character
    I can make conditional format based on 1st letter, I have highlighted texts that begin with letter "A"
    =LEFT(A1,1)="A"
    now I am wondering if it is possible to highlight cells that 1st letter is A and 3rd letter is B?

    Thank you

    screenshot.5836.jpg
    Attached Files Attached Files
    Last edited by Excl3454; 03-12-2021 at 03:25 PM.
    Reply With QuoteRegister To Reply
  2. 03-12-2021, 03:20 PM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,339

    Re: conditional format cells based on first letter and other?

    =and(left(a1,1)="a",mid(a1,3,1)="b")
    Reply With QuoteRegister To Reply
  3. 03-12-2021, 03:24 PM #3
    Excl3454
    Excl3454 is offline
    Registered User
    Join Date
    01-29-2021
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    93

    Re: conditional format cells based on first letter and other?

    Quote Originally Posted by JohnTopley View Post
    =and(left(a1,1)="a",mid(a1,3,1)="b")
    Thank you so much for your very quick respond John. best
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting based on the conditional format of other cells
    By mmcalpin in forum Excel General
    Replies: 1
    Last Post: 08-19-2016, 03:57 PM
  2. [SOLVED] Is it possible to format cells based on their value? (Not a conditional format query)
    By The_Snook in forum Excel General
    Replies: 2
    Last Post: 09-26-2012, 04:43 AM
  3. [SOLVED] Apply Conditional Format to a range of cells based on other Cells
    By rau in forum Excel General
    Replies: 3
    Last Post: 09-13-2012, 03:25 AM
  4. [SOLVED] conditional format last letter before numbers
    By grizzly6969 in forum Excel General
    Replies: 7
    Last Post: 06-12-2012, 04:12 AM
  5. Conditional Format based on two different cells
    By jcowley in forum Excel General
    Replies: 6
    Last Post: 05-12-2010, 10:34 AM
  6. Conditional Format based on value of other cells
    By robotlust in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-30-2007, 09:30 PM
  7. Conditional format based on other cells
    By Tonto in forum Excel General
    Replies: 1
    Last Post: 07-07-2006, 01:15 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1