+ Reply to Thread
Results 1 to 2 of 2

Conditionial formatting for merged cells, function Len($A$4)

  1. #1
    CajunWebfoot
    Guest

    Conditionial formatting for merged cells, function Len($A$4)

    Need to have the function len as a conditional format function for merged
    cells.
    Doesn't seem to work for merged cells.


  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    The Conditional Formatting should work in merged cells, whether the merged cells are the ones with the CF or are the ones referenced by the CF (or both). The Condition 1 should read:

    Formula Is: =LEN($A$4)>2
    and set your format (adjust the desired length to suit your needs)

    Does this work for you?

    Bruce
    Bruce
    The older I get, the better I used to be.
    USA

+ 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