+ Reply to Thread
Results 1 to 10 of 10

Fill blank cells with color in Excel

  1. #1
    Forum Contributor
    Join Date
    07-04-2018
    Location
    Dallas
    MS-Off Ver
    2016
    Posts
    124

    Fill blank cells with color in Excel

    Hello,

    I have a requirement where if CoCode (Col J) is not blank and any other cells are blank.the blank cells are filled in red color.

    I have written the code to fill the cells, but it give 400 error. Attached the file. Please advice what is missing in the code.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-08-2020
    Location
    South Korea
    MS-Off Ver
    Excel 2010
    Posts
    100

    Re: Fill blank cells with color in Excel

    Please Login or Register  to view this content.
    Caring environment and nature. caring you.

  3. #3
    Forum Contributor
    Join Date
    07-04-2018
    Location
    Dallas
    MS-Off Ver
    2016
    Posts
    124

    Re: Fill blank cells with color in Excel

    Thanks Chronjy.

    This works, but my requirement is to have this enabled only if col J is not blank. I see this works for all the rows with in the range where we do not have any data submitted.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: Fill blank cells with color in Excel

    Quote Originally Posted by BMD4 View Post
    I have a requirement where if CoCode (Col J) is not blank and any other cells are blank.the blank cells are filled in red color.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-04-2018
    Location
    Dallas
    MS-Off Ver
    2016
    Posts
    124

    Re: Fill blank cells with color in Excel

    Thanks Jindon.

    Can you please let me know how can we limit the number of columns to which the logic is applied. Eg: non sequential columns. Col 5 and 7

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: Fill blank cells with color in Excel

    Quote Originally Posted by BMD4 View Post
    Eg: non sequential columns. Col 5 and 7
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    07-04-2018
    Location
    Dallas
    MS-Off Ver
    2016
    Posts
    124

    Re: Fill blank cells with color in Excel

    can you please help me understand what is RC10 and RC in the logic

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: Fill blank cells with color in Excel

    That's R1C1 notation for cell address reference.
    r = same row, c10 means col.10 = "J"
    rc = cell that the conditional formatting will be applied to.

    so that you can change base column "E"
    Please Login or Register  to view this content.
    to any other column, if needed.

  9. #9
    Forum Contributor
    Join Date
    07-04-2018
    Location
    Dallas
    MS-Off Ver
    2016
    Posts
    124

    Re: Fill blank cells with color in Excel

    Hi Jindon,

    I see the logic is applied to all the columns. Attached the file. Can you pelase advise.

  10. #10
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,145

    Re: Fill blank cells with color in Excel

    If so, you didn't delete the remaining conditional format.
    Please Login or Register  to view this content.

+ 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] How to fill color cells based on another cell's fill color?
    By putritersenyum in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2016, 08:58 AM
  2. [SOLVED] make blank cells color fill after typing in text
    By oliver1712 in forum Excel General
    Replies: 4
    Last Post: 12-10-2014, 01:52 PM
  3. Color Fill Blank Cells
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2013, 01:11 PM
  4. How to color-fill blank cells, then once data is entered cell is no-fill
    By hatemail13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-28-2013, 07:57 PM
  5. [SOLVED]Fill Color (highlight cells) but not to print fill color
    By itszille in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-24-2012, 05:37 PM
  6. Excel 2003 will not display color fonts or color fill cells
    By DaveC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-11-2005, 12:06 PM
  7. My excel 2003 wont let me fill cells with color or color the tabs.
    By trizog in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-23-2005, 01:58 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