Results 1 to 8 of 8

Troubleshooting with AND Formula in Conditional Formatting

Threaded View

  1. #1
    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.

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. [SOLVED] 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1