+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting if Column A is blank vs. if it's not

  1. #1
    Registered User
    Join Date
    02-16-2015
    Location
    Coloroado
    MS-Off Ver
    2013
    Posts
    4

    Conditional Formatting if Column A is blank vs. if it's not

    Hello,

    I am working on an Excel report for work. I've essentially created a template where my coworker can copy and paste data from another program, and Excel will format it correctly. The first column lists individuals' names, while three following columns give dates. I set up color scale formatting for the dates, so if they are past a certain threshold, they turn red; if they are nearing the threshold, they turn orange; and if they are far from the threshold, they are green.

    Unfortunately the other program where we house the data has occasional blank lines mixed in with the data we need. My coworker would like me to set up the formatting so that if Column A is blank, the date columns have no special formula--they are just blank with white background. However, if Column A is filled and the date columns are blank, he'd like for the date columns to turn red. I can figure out how to set up conditional formatting for the blanks to turn red, but I'm struggling to find a way to have blanks connected to a blank Column A stay without formatting. I tried adding a rule that relies on this formula for formatting: =$A2="". But if I get it to work, the other blanks stop turning red.

    I'd be grateful for any suggestions anyone has! Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,414

    Re: Conditional Formatting if Column A is blank vs. if it's not

    Hello and welcome to the forum,

    If I understood correctly, try this condition for the red cells :
    Please Login or Register  to view this content.
    Assuming column B is the Date
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Registered User
    Join Date
    02-16-2015
    Location
    Coloroado
    MS-Off Ver
    2013
    Posts
    4

    Re: Conditional Formatting if Column A is blank vs. if it's not

    Thanks so much! That did the trick!

+ 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. Replies: 3
    Last Post: 02-09-2015, 09:00 AM
  2. Conditional formatting to apply only on the last non blank cell in a column
    By st_judeu@yahoo.com in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-28-2014, 02:53 AM
  3. [SOLVED] 3 Outcomes Conditional Formatting based on 4 blank/non blank cells
    By Supraman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-14-2012, 06:21 AM
  4. conditional formatting:highlight row based on blank or non-blank c
    By Nat Maxwell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2005, 08:15 PM
  5. conditional formatting:highlight row based on blank or non-blank c
    By Nat Maxwell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-30-2005, 06:30 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