+ Reply to Thread
Results 1 to 3 of 3

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

Hybrid View

  1. 02-16-2015, 10:17 PM #1
    GC Excel
    GC Excel is offline
    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 : 
    =AND($B2="",$A2<>"")
    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.
    Reply With QuoteRegister To Reply
  2. 02-17-2015, 07:49 PM #2
    ShelM
    ShelM is offline
    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 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. Conditional Formatting - how to leave blank cells blank - no colour until date populated
    By leanne2011 in forum Excel General
    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. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1