Results 1 to 14 of 14

How to conditionally format a dynamic range

Threaded View

  1. #1
    Forum Contributor JulianS96's Avatar
    Join Date
    11-01-2019
    Location
    England
    MS-Off Ver
    365 (work-99%), 2016 (home-1%)
    Posts
    283

    How to conditionally format a dynamic range

    Hey Forum,

    I am wondering how to conditionally format a range which may expand vertically or horizontally at any point, if more line items are added.
    The Conditional format is essentially blocking out any Blank cell and turning it grey (see example)
    I would like the conditional format to make all the cells that are empty, grey where:
    For rows: Where there is text on the preceding row, add + 1 to the conditional format so it formats the next row as grey.
    For columns: Where there is text on the preceding column, add + 1 to the conditional format so it formats the next column as grey.

    Kind Regards,

    Julian

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to conditionally format columns based on dynamic cell values
    By LukeMac2 in forum Excel General
    Replies: 10
    Last Post: 08-28-2023, 01:18 AM
  2. Replies: 6
    Last Post: 07-21-2022, 07:03 AM
  3. [SOLVED] Conditionally format a range in Excel 2003?
    By Carson Dyle in forum Excel General
    Replies: 5
    Last Post: 11-09-2016, 06:46 PM
  4. VBA to Conditionally format date range on calendar
    By am_hawk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2014, 04:44 PM
  5. Need help for macro to conditionally format a selected range
    By smusyaju in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2014, 04:44 PM
  6. [SOLVED] Conditionally Format Dynamic Range
    By hamidxa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2014, 12:43 PM
  7. [SOLVED] Vba code to conditionally format a specific range
    By kelwood in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-29-2012, 10:14 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