+ Reply to Thread
Results 1 to 3 of 3

Convert count Blak formula into given Rage i.e (LEN(B4)=0)

  1. #1
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Sweden
    Posts
    311

    Convert count Blak formula into given Rage i.e (LEN(B4)=0)

    Greetings,

    Hope you all having a great time

    Working Hard but not able to com-up with the solution to convert formula into given Rage, I want to use below formula in range instead of assigning Cells Number 'one by one' in conditional formatting to highlight cells that just appear blank in give range i.e (=B4:L4)

    i am using this formula:
    Please Login or Register  to view this content.
    any help will be highly appreciated.

    Best,

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Convert count Blak formula into given Rage i.e (LEN(B4)=0)

    select all of the cells

    Conditional Formatting_New formatting rule_Format only cells that contain

    then cell value, equal to, 0


    if 0 is really blank

  3. #3
    Forum Contributor
    Join Date
    06-09-2014
    Location
    Sweden
    Posts
    311

    Re: Convert count Blak formula into given Rage i.e (LEN(B4)=0)

    HI,

    Thank you Problem Solved appreciated

+ 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] Lookup in looked-up rage
    By Evolta in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-04-2015, 08:34 AM
  2. [SOLVED] VBA to remove blak cells in a row and output values in consecutive cells
    By ywang in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-07-2014, 04:38 AM
  3. [SOLVED] Duplicates within a date rage
    By sori4289 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-11-2013, 05:48 AM
  4. sum a named rage except the last row
    By alexandruc in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-27-2010, 09:05 AM
  5. [SOLVED] Sum by date rage using multiple sheets
    By Michael in forum Excel General
    Replies: 3
    Last Post: 03-24-2006, 07:51 PM
  6. Replies: 7
    Last Post: 07-02-2005, 04:06 PM
  7. how do you use a variable a rage?
    By dm16s in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2005, 11:05 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