+ Reply to Thread
Results 1 to 8 of 8

Conditional formating based on cell value

  1. #1
    Forum Contributor
    Join Date
    12-03-2021
    Location
    Brussels
    MS-Off Ver
    Microsoft 365
    Posts
    127

    Conditional formating based on cell value

    Please check the attachment.

    In REVENUES > Conditional Formatting :

    I want to turn grey the text of all rows where the Column M = "received" or "canceled"

    but problem is that there is another value "to receive" that get mixed by Excel with "receive" as the later is contained by the former

    Anyone can help me fix a formula for this conditional formating?

    Thanks
    Simon
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by jeriss; 04-11-2022 at 10:40 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,772

    Re: Conditional formating based on cell value

    Select cells from row 3 down and use:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,233

    Re: Conditional formating based on cell value

    =OR($M1="received",$M1="canceled")
    will do it

    I noted the spelling of canceled is with a single L
    also you selected the range from row 1 - so formula needs to have row1
    Attached Files Attached Files
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Contributor
    Join Date
    12-03-2021
    Location
    Brussels
    MS-Off Ver
    Microsoft 365
    Posts
    127

    Re: Conditional formating based on cell value

    Thanks for your answers.

    I tried to reproduce the formula but I don't understand why it doesn't want to work when I enter it.

    See file below with the formula adjusted as suggested, but not working.
    Attached Files Attached Files

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,233

    Re: Conditional formating based on cell value

    you need to select the area you want the formatting to apply to

    so if you select A3 to Z100 for example
    then the formula needs to start at row 3
    if you select A2 to Z100
    then the formula starts at row 2

    So if you select the sheet


    REVENUES!$B$2:$N$10485762
    then as your selection starts in row 2 - B2

    Then the formula
    =OR($M2="received",$M2="cancelled")

    i notice the cancelled now has 2 L's
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    12-03-2021
    Location
    Brussels
    MS-Off Ver
    Microsoft 365
    Posts
    127

    Re: Conditional formating based on cell value

    Wonderful ! Thank you so much all !

  7. #7
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,233

    Re: Conditional formating based on cell value

    you are welcome

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,772

    Re: Conditional formating based on cell value

    Ditto. You're welcome.

+ 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 Formating Based on Other Cell Value
    By SeaLawyer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-12-2020, 01:35 PM
  2. Conditional Formating based on < > a different cell.
    By exc1967 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2018, 12:31 PM
  3. Conditional Row Formating based on one cell of the row
    By Aredmon25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2012, 11:37 AM
  4. conditional formating based on other cell value
    By tinkerbelle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2009, 01:41 PM
  5. Conditional Formating based on different cell
    By nikoky in forum Excel General
    Replies: 3
    Last Post: 02-24-2007, 10:01 AM
  6. Replies: 2
    Last Post: 05-05-2005, 04:06 PM
  7. Conditional Formating based on another cell
    By SMac in forum Excel General
    Replies: 6
    Last Post: 03-10-2005, 04:06 PM

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