+ Reply to Thread
Results 1 to 3 of 3

Google Sheets - Conditioned formatting of a cell in relation to another cell

  1. #1
    Registered User
    Join Date
    03-25-2022
    Location
    Munich
    MS-Off Ver
    2019
    Posts
    5

    Google Sheets - Conditioned formatting of a cell in relation to another cell

    Hello!

    Cell B1 should be colored red if cell A1 contains a certain string.

    I thing this should be possible but I don't succed.

    Thank you in advance for your answer!
    Last edited by Hans Huber; 03-30-2022 at 07:23 AM.

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Google Sheets - Conditioned formatting of a cell in relation to another cell

    select cell B1
    go to Format > Conditional Formatting
    change "Format rules" to Custom formula is
    put in the formula:
    Please Login or Register  to view this content.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Registered User
    Join Date
    03-25-2022
    Location
    Munich
    MS-Off Ver
    2019
    Posts
    5

    Re: Google Sheets - Conditioned formatting of a cell in relation to another cell

    Thank you!!!

+ 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. Google Sheets: Condition formatting in Google sheet
    By cyee in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 02-18-2021, 05:35 PM
  2. [SOLVED] Google Sheets Conditional Formatting based on another cell value
    By Badvgood in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 12-16-2020, 12:07 PM
  3. Google Sheets: Formatting a cell with 0.00000000
    By Jetheat in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 12
    Last Post: 05-14-2020, 02:56 PM
  4. [SOLVED] Google Sheets: conditional formatting for cell containing letters and numbers
    By jher001 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 04-13-2018, 03:18 PM
  5. Replies: 3
    Last Post: 04-05-2017, 07:49 AM
  6. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  7. Replies: 9
    Last Post: 03-24-2008, 03:04 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1