Show last entry in column as bold

[Galceran]

Col F is formatted for Accounting. The max entries is 52. When a new entry is pasted I want it Bold, preceeding numbers in this col to show as normal. Only the last entry to show bold. I have tried Conditional Formatting with OFFSET but it seems to be volatile.
Am I on the right formula?

 

[T. Valko]

Col F is formatted for Accounting. The max entries is 52. When a new entry is pasted I want it Bold, preceeding numbers in this col to show as normal. Only the last entry to show bold. I have tried Conditional Formatting with OFFSET but it seems to be volatile.
Am I on the right formula?

Try this...

Assume the range of interest is F2:F53.

Use this formula for the conditional format rule:

=ROW(F2)=LOOKUP(1E100,F$2:F$53,ROW(F$2:F$53))

 

[Aladin Akyurek]

Col F is formatted for Accounting. The max entries is 52. When a new entry is pasted I want it Bold, preceeding numbers in this col to show as normal. Only the last entry to show bold. I have tried Conditional Formatting with OFFSET but it seems to be volatile.
Am I on the right formula?

Select column F.

And invoke the following formula in CF...

=ROW()=MATCH(9.99999999999999E+307,$F:$F)

Apply desired formatting.

 

[mikerickson]

I would use CF (on A1) with the formula

=AND(COUNTA(A1:A$9999)=1, COUNTA(A1)=1)

and copy to the rest of the cells.

The second argument of the AND is not strictly needed for Bolding, but it is if you want a fill included with the conditional format.

 

[Galceran]

Well I have tried both formula and Yes they both provide the answer. I shall use one of them but avoid saying which one. In case it's taken as a slight sign of favourtism

Thanks VM
Gilbert

 

[T. Valko]

Well I have tried both formula and Yes they both provide the answer. I shall use one of them but avoid saying which one. In case it's taken as a slight sign of favourtism

Thanks VM
Gilbert

Thanks for the feedback!

 

[Aladin Akyurek]

Well I have tried both formula and Yes they both provide the answer. I shall use one of them but avoid saying which one. In case it's taken as a slight sign of favourtism

Thanks VM
Gilbert

I trust you did the right thing... Thanks for providing feedback.