+ Reply to Thread
Results 1 to 2 of 2

Google Sheets: Conditional Formatting with multiple cells

  1. #1
    Forum Contributor
    Join Date
    03-04-2013
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    130

    Google Sheets: Conditional Formatting with multiple cells

    Sorry in advance I know this isn't the Google help forum, but I'm trying to learn after a lifetime of excel.

    How would I format cell A2 to simply change colour based on the following:

    A1 is not blank (=NOT(ISBLANK(A1)), A2 contains the text "yes" , A3 is Blank (=ISBLANK(A3))

    I think that's the correct code I just cant work out how to string it together.
    Last edited by JohnDoh; 01-22-2021 at 04:48 AM.

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Google Sheets: Conditional Formatting with multiple cells

    The Other Platforms forum is for Google's stuff.

    Use a custom formula like =and(counta(A1),countif(A2,"*yes*"),isblank(a3)).

    See this example.

+ Reply to 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 from multiple cells.
    By JChandler8314 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2020, 09:47 PM
  2. Conditional Formatting on Multiple Cells
    By dgaletar in forum Excel General
    Replies: 8
    Last Post: 05-04-2016, 03:54 PM
  3. [SOLVED] Conditional Formatting over multiple cells with multiple criteria validator
    By effendrew in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-31-2015, 05:05 PM
  4. [SOLVED] Conditional formatting multiple cells based on multiple cells
    By jhuvba in forum Excel General
    Replies: 2
    Last Post: 05-18-2015, 12:19 PM
  5. [SOLVED] Conditional Formatting based on multiple strings in multiple cells
    By lily_ruiz_06 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2013, 04:23 PM
  6. Conditional Formatting Multiple Cells
    By Edsaid in forum Excel General
    Replies: 3
    Last Post: 10-04-2010, 08:15 AM
  7. Conditional Formatting Across Multiple Cells
    By TheLeafs in forum Excel General
    Replies: 3
    Last Post: 05-28-2009, 09:51 AM

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