Pls see the below mentioned details, how can we highlight balance coloumn as per system date (12.03.13) need to highlight only similar date last entered cell

DATE DESCRIPTION AMOUNT BALANCE
31-Jan-13 Opening Balance - 100.000
01-Mar-13 Test 10.000 90.000
05-Mar-13 Test 2.000 88.000
12-Mar-13 Test 50.000 38.000
12-Mar-13 Test 4.000 34.000 -- Need Hight

We are maintaing a excel sheet, Its having 11 Coloumns, After
Entering the
data on Every Cell Need to Lock cell with Password.
Please help me.

Easily done!

First, unlock all cells to receive input.
Second, protect the sheet (password optional)
Third, right-click the sheet tab and select 'View code' from the popup
menu.
Finally, past the following code into the code window...


Option Explicit
Const PWD$ = "password" '//edit ti suit

Private Sub Worksheet_Change(ByVal Target As Range)
With Me
.Unprotect PWD: Target.Locked = True: Protect PWD
End With
End Sub

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion