Results 1 to 5 of 5

(SOLVED) Highlight a range of cells until every cell in that range contains data

Threaded View

  1. #1
    Registered User
    Join Date
    05-03-2017
    Location
    Rijen, Netherlands
    MS-Off Ver
    2011
    Posts
    11

    (SOLVED) Highlight a range of cells until every cell in that range contains data

    I try achieve, with conditional formatting, to highlight (background color) a range of cells until every cell in that particular range is filled with data.
    For example the cells a1:d1 should contain data, when so...the background of these cells should turn green for example.
    Is that possible with conditional formatting?
    Last edited by rvfotopro; 05-13-2017 at 04:59 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 04-12-2015, 02:47 AM
  2. Highlight cell range if 1 particular cell in range contains data
    By oliver1712 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2015, 12:57 PM
  3. Highlight one cell based on a range of cells
    By claire_wilson in forum Excel General
    Replies: 3
    Last Post: 12-16-2014, 07:15 PM
  4. [SOLVED] macro to compare a range with a standard range and highlight cells, when not matched
    By excelhelpseeker in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-27-2014, 12:46 PM
  5. [SOLVED] UDF concatenate randomly chosen cells from range (Horizontal Range)
    By cheesefry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2014, 03:54 AM
  6. Highlight or colour a cell or cells based on cells in another range.
    By baffld in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2012, 08:41 PM
  7. [SOLVED] Highlight range of cells - run macro - select last cell in range
    By chromachem in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2012, 11:46 AM

Tags for this Thread

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