Conditional Cell Formatting to Add Border to Column When Data Entered in Any Part of Colum

Hi Gang,

I have a column that with data in it's rows, could be 5 rows or 100, it varies all the time. Data will exist in it's rows are varying cells (it's spotty).

Basically, I'm trying to get conditional formatting to work so as that as soon as someone enters data in any part of the column (could be row 5 or row 25, or row 100, etc, it varies), a long vertical line shows up along the column. This vertical divider would start at row 3 (where the data begins) and continue to the point where the last row of data exists (all within the same column).

I can get the vertical line to show up, just for the specific cell in which data was entered in. I can't get it to exist from row 3 to the last cell containing data.

Anyone have a suggestion(s)?

As always, your help is appreciated.

Thank you,

JRUB

In CF try this..

=COUNTA(C3:C$65536)

format vertical border