+ Reply to Thread
Results 1 to 5 of 5

conditional formatting based on a series of column text values

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    4

    conditional formatting based on a series of column text values

    Hi everyone. I have a table with a column of names that need to be color formatted if the adjacent columns have certain text contents - e.g. column A will be formatted if column B and column C contain "ok" and column D contains "N/A". If these criteria are not met, no formatting is required. Can anyone help?

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: conditional formatting based on a series of column text values

    hi stewphil, welcome to the forum. select the range you want to apply to (for eg A2:A10), go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
    =AND($B2="ok",ISNA($C2))

    format the colour you desire & click ok

  3. #3
    Registered User
    Join Date
    08-16-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: conditional formatting based on a series of column text values

    Hi benishiryo, thanks for the quick reply, but N/A is text for Not Applicable.

  4. #4
    Registered User
    Join Date
    08-16-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: conditional formatting based on a series of column text values

    Hi benishiryo, is it possible to give you a sample of the spreadsheet so you get a better idea?

  5. #5
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: conditional formatting based on a series of column text values

    Hi stewphil -

    You can attach your sample file here.

    Regards,
    Event

+ 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