In conditional formatting, if you change the

Cell value is

to
Formula is
in the dropdown, you can write a formula that is not dependent on the value
of the active cell.

If the column will not have embedded blanks - so if the next cell is blank,
then do the underline, you could select the column with the cell in row 1 as
the activecell and do (assume column C with C1 active)

formula is =$C1=""

then set the formatting to underline

--
Regards,
Tom Ogilvy


"manxman" wrote:

I have a form where I want the last entry in a column of numbers to be
underlined. Always entering from the top down, I want it so that if there is
one entry, it would be underlined, but if more entries are made, the
underline would always be under the last entry. The column is generally of
fixed length, although I do need to expand it on occasion.

How do I code this? Conditional formatting seems to be based only on the
conditions in that cell, not other cells. I assume Ill need to go to VBA.
Thanks in advance for any help.