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

C

CajunWebfoot

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

swatsp0p

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
 
Top