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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need to have the function len as a conditional format function for merged
cells.
Doesn't seem to work for merged cells.
 
The Conditional Formatting should work in merged cells, whether th
merged cells are the ones with the CF or are the ones referenced by th
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?

Bruc
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
HELP!!!!!!!!! 2
How to subtract a number from a Mergefield? 0
Merging cells in a Protected Sheet 2
Merge Cells 4
How do I get warpped data to auto fit in merged cells? 2
Sharing workbooks limitations - Merged Cells 12
Conditional Format - Hide/Unhide 2

Back
Top