Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Member
 
Posts: 36
Default Highlight Cell as per System Date

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,514
Default Cell Auto Lock After Entering

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.


Already answered in your post to the
'microsoft.public.excel.programming' forum.

--
Garry

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlight Cell as per System Date Moideen Excel Programming 1 March 12th 13 07:53 PM
Convert military date system to standard date system John Weaver Excel Discussion (Misc queries) 8 September 17th 09 06:12 PM
Changing values in cell based on system date [email protected] Excel Worksheet Functions 2 October 24th 08 07:33 AM
How can I get the system date & time for different cell record Get System Date & Time Excel Discussion (Misc queries) 8 January 9th 08 01:20 AM
HOW DO I FORMAT A CELL IN EXCEL TO PICK CURRENT SYSTEM DATE mechi Excel Programming 2 August 17th 07 01:33 PM


All times are GMT +1. The time now is 01:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"