Displaying in Bold for last entry

[Diego Garcia]

I have a workbook for my bank account. Col D is for debit entries, Col E for credit entries whilst Col F is the balance. The formula in the Balance column is =IF(AND(ISBLANK(D19),ISBLANK(E19)),"",F18-D19+E19)
I would like the latest entry to display in Bold, the previous entries being in Regular font style. As each new entry is made the preceeding balance reverts to regular font and the new entry is in Bold. How could I do this ?

 

[RichardS]

Try conditional format.

In say cell F9, Use conditional format with the formula

=OFFSET(F9,1,0)=0)

and set your format to bold. Copy the format to relevant cells.

Richard

_________________
The world is but a stage, and it ain't over 'till the Fat Lady sings
This message was edited by RichardS on 2002-08-08 23:53

 

[Diego Garcia]

returns "FALSE" for all cells.

 

[RichardS]

Change to

=OFFSET(F9,1,0)="".

Should have looked closer at your formula, it returns "" if nothing is in your debit/credit column, not 0. Sorry.

Richard

 

[Diego Garcia]

Thats fine if I put your formula in a seperate column but I can't get the value in Col F to display in Bold. Tried adding
*(OFFSET(F21,1,0)="")
to my formula in Col F but did not work.

 

[RichardS]

Sorry, you misunderstood. This is conditional formatting.

On the format menu, select conditional Formatting. In the drop down box, select "Formula is", then type the formula in the box to the right. Click on the Format button, and select your desired formula. Click OK.

HTH

Richard

 

[Aladin Akyurek]

On 2002-08-09 00:46, Diego Garcia wrote:
Thats fine if I put your formula in a seperate column but I can't get the value in Col F to display in Bold. Tried adding
*(OFFSET(F21,1,0)="")
to my formula in Col F but did not work.

( 1.) Select all the relevant cells in F.
( 2.) Activate Format|Conditional Formatting.
( 3.) Choose Formula Is for Condition 1.
( 4.) Enter in the formula box:

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

I assumed here that the data in F starts in F2, otherwise adjust to fit. One thing: Do not include $ signs.

( 5.) Activate the Format button.
( 6.) Choose bold on the Font tab.
( 7.) Click OK, OK.

 

[Diego Garcia]

Wonderful. I am familiar with Conditional formatting - well I thought I was ! but was not aware of being able to enter a formula. Thanks very much to both of you

 

[Son Raphon]

Dear all, ask above problem I want to set bold by category.
Example: Cash is set bold for last statement. And other accounts we set bold for the last statement the same.
Anyone, could you help me?