+ Reply to Thread
Results 1 to 8 of 8

Troubleshooting with AND Formula in Conditional Formatting

  1. 06-06-2020, 10:48 AM #1
    rileymo
    rileymo is offline
    Registered User
    Join Date
    06-06-2020
    Location
    Iowa, USA
    MS-Off Ver
    Windows 10
    Posts
    4

    Unhappy Troubleshooting with AND Formula in Conditional Formatting

    A bit of newbie to this, so I'll try to explain well. Set up some color-coded conditional formatting so that if a cell ends with a certain letter (e.g. "W"), it will change the cell background to certain color. That all worked fine and dandy, but now I'm trying to get it so if a cell is blank, it will match the formatting of the cell to the left.

    Here is the formula I came up with:

    =AND(ISBLANK,$B9="*W")

    pic1.jpg
    pic2.jpg

    Pictures attached above for further clarity.

    So far, the formula is doing nothing, though I can't figure out what I did wrong. Thanks in advance for your help.
    Attached Files Attached Files
    Last edited by rileymo; 06-06-2020 at 11:17 AM.
    Reply With QuoteRegister To Reply
  2. 06-06-2020, 11:01 AM #2
    Vraag en antwoord
    Vraag en antwoord is offline
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Troubleshooting with AND Formula in Conditional Formatting

    =and(isblank(c9),$b9="*w")

    Otherwise, just place the file. We can't do much with pictures.
    Reply With QuoteRegister To Reply
  3. 06-06-2020, 11:15 AM #3
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Troubleshooting with AND Formula in Conditional Formatting

    Maybe
    =AND(C9="",RIGHT(B9)="W")
    Reply With QuoteRegister To Reply
  4. 06-06-2020, 11:15 AM #4
    rileymo
    rileymo is offline
    Registered User
    Join Date
    06-06-2020
    Location
    Iowa, USA
    MS-Off Ver
    Windows 10
    Posts
    4

    Re: Troubleshooting with AND Formula in Conditional Formatting

    Unfortunately that formula still isn't working for me. Let me add the file.
    Reply With QuoteRegister To Reply
  5. 06-06-2020, 11:19 AM #5
    rileymo
    rileymo is offline
    Registered User
    Join Date
    06-06-2020
    Location
    Iowa, USA
    MS-Off Ver
    Windows 10
    Posts
    4

    Re: Troubleshooting with AND Formula in Conditional Formatting

    How do I delete a reply haha
    Last edited by rileymo; 06-06-2020 at 11:22 AM.
    Reply With QuoteRegister To Reply
  6. 06-06-2020, 11:20 AM #6
    rileymo
    rileymo is offline
    Registered User
    Join Date
    06-06-2020
    Location
    Iowa, USA
    MS-Off Ver
    Windows 10
    Posts
    4

    Re: Troubleshooting with AND Formula in Conditional Formatting

    Quote Originally Posted by Fluff13 View Post
    Maybe
    =AND(C9="",RIGHT(B9)="W")
    Winner winner! This one worked! Thank you!
    Reply With QuoteRegister To Reply
  7. 06-06-2020, 11:21 AM #7
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Troubleshooting with AND Formula in Conditional Formatting

    You're welcome & thanks for the feedback.
    Reply With QuoteRegister To Reply
  8. 06-06-2020, 11:22 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Troubleshooting with AND Formula in Conditional Formatting

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    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. [SOLVED] Problems troubleshooting a formula
    By thedunna in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-20-2017, 09:21 PM
  2. [SOLVED] Theory Post: Array Formula Troubleshooting
    By The_Snook in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-02-2017, 01:49 PM
  3. [SOLVED] And or formula conditional formatting troubleshooting
    By kschmit1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2016, 12:48 PM
  4. Lookup Formula Troubleshooting
    By AK de FLA in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2016, 09:28 PM
  5. Formula Troubleshooting - Checking two lists for matches
    By kimball.r in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-10-2012, 05:01 PM
  6. Troubleshooting Sumproduct and Countif formula
    By dcgrove in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-15-2008, 04:19 AM
  7. Troubleshooting my IF formula
    By Kim in forum Excel General
    Replies: 5
    Last Post: 06-26-2006, 06: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