+ Reply to Thread
Results 1 to 7 of 7

Conditional format formula for highlighting a column that is blank

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Conditional format formula for highlighting a column that is blank

    Good morning all

    My first post, thus far all my previous questions have been answered by searching the forum.

    I have a spreadsheet that has 200 rows and 275 columns.
    As you will see in the example it is to do with comparing files with their functions. If a file uses a certain function then there is a "X" in the cell.
    What I would like to do is highlight the columns that are completely blank (We are trying to reduce the functions in the system so would like to see which ones are not being used at all)
    In my example the outcome would be that Column C, D, F, G, H, I, J, and K would be highlighted as there is no data inside any of the cells.

    Thank you for any upcoming help in this.
    Attached Files Attached Files

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Conditional format formula for highlighting a column that is blank

    conditional format b2 as =COUNTIF(B$2:B$14,"x")=0 adjust rows to suit and copy format across al cells
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Conditional format formula for highlighting a column that is blank

    Hello try this one.

    data example.xlsx
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  4. #4
    Registered User
    Join Date
    08-16-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Conditional format formula for highlighting a column that is blank

    Thank you for your prompt reply.

    This has solved my problem.

    I am unsure how to mark the thread as solved though??

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Conditional format formula for highlighting a column that is blank

    Thanks from both of us.
    Go to your first post, click Edit then follow the steps on my signature below.

  6. #6
    Registered User
    Join Date
    08-16-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Conditional format formula for highlighting a column that is blank

    If only I had have read your signiture the first time.....

    Thank you once again.

  7. #7
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Conditional format formula for highlighting a column that is blank

    You very much welcome.

    Cheers.
    Regards,
    Vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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