LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
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
Convert military date system to standard date system John Weaver Excel Discussion (Misc queries) 8 September 17th 09 06:12 PM
How do I highlight a cell when a date is overdue? Bel Excel Discussion (Misc queries) 1 March 18th 09 03:06 AM
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 10:11 PM.

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

About Us

"It's about Microsoft Excel"