+ Reply to Thread
Results 1 to 8 of 8

Conditional Formatting if other cells are empty

  1. #1
    Registered User
    Join Date
    09-15-2013
    Location
    scotland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Conditional Formatting if other cells are empty

    Hi

    I need to use conditional formatting to turn cell red, amber or green if previous three cells are not
    populated and green if they are.

    Any suggestions please : ))))
    Attached Files Attached Files

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Conditional Formatting if other cells are empty

    maybe like this:

    1) Highlight F6:F233
    2) Apply this conditional formatting rule:

    =OR($L6,$M6,$N6=0)
    ...color red.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    09-15-2013
    Location
    scotland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Conditional Formatting if other cells are empty

    Thanks, however this is making the the whole column red. Any other suggestions?? : )

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,735

    Re: Conditional Formatting if other cells are empty

    You don't say what previous means. Is it the three above or the three to the left in the same row?
    Why do your formulas look at columns L, M, N, which are empty?
    My attachment looks to the left of column F.
    Attached Files Attached Files
    Last edited by protonLeah; 09-15-2013 at 08:27 PM.
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    09-15-2013
    Location
    scotland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Conditional Formatting if other cells are empty

    Hi

    It refers to the 3 to the left C, D and E. So basically if 1 is populated then red, 2 then amber and all three green. Do you think this is possible, would be a huge help!! : )

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Conditional Formatting if other cells are empty

    So, change the formula I gave you to reference those columns instead of L, M and N, which is what you had in there originally.

  7. #7
    Registered User
    Join Date
    09-15-2013
    Location
    scotland
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Conditional Formatting if other cells are empty

    Thank you!! This really helps : )))

  8. #8
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Conditional Formatting if other cells are empty

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

+ 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. [SOLVED] Conditional formatting - empty rows
    By suhi in forum Excel General
    Replies: 6
    Last Post: 04-26-2012, 07:08 AM
  2. Replies: 5
    Last Post: 03-14-2012, 04:46 PM
  3. Conditional formatting with empty cell
    By dadel in forum Excel General
    Replies: 13
    Last Post: 07-08-2009, 10:24 AM
  4. Conditional Formatting of blank/empty cells in Excel 2007
    By OverKnight in forum Excel General
    Replies: 4
    Last Post: 01-09-2009, 05:39 PM
  5. Conditional Formatting Color Empty Cells in a Colum
    By rmm30 in forum Excel General
    Replies: 2
    Last Post: 09-28-2006, 09:35 AM

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