Am using a banking file in this file having 5 Coloumn Date, Particular, Debit, Credit, Balance. Please help me to highlight the current dated latest Cell

Please find the attached file, on 9th Need to Automatic highlight Cell : E6

Hi,

Am Sat, 8 Mar 2014 18:01:46 +0000 schrieb Moideen:

Please find the attached file, on 9th Need to Automatic highlight Cell :
E6

if you only want to color E6 then select E1:En = CF = Formula:
=E1=LOOKUP(9^99,E:E)
If you want to color the last row then select A1:En = CF = Formula:
=$E1=Lookup(9^99;$E:$E)


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Dear Sir,

Where can i enter this formula, please explain

Hi again,

Am Wed, 26 Mar 2014 19:31:54 +0000 schrieb Moideen:

Where can i enter this formula, please explain

select your range (E1:En) then go to Conditional Formatting = Use
formula to determine.... and enter the formula into the formula bar.
If you don't get it to work please post here if you want to color the
last cell in column E or if you want to color the last row. Then I will
upload a example file.


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional

Sir,

Please find the attached file, Need to automatic highlight every day current date last row. Eg. Row 7

Hi,

Am Thu, 27 Mar 2014 13:53:20 +0000 schrieb Moideen:

Please find the attached file, Need to automatic highlight every day
current date last row. Eg. Row 7

please look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for the workbook "Today"


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional

Thank You Very Much

Dear Sir,

When i insert new row above current date (Eg. Row E10, Inserted New Row) both rows are hightlighted, Please note When i inset new row below current date it working fine, pls do the needful, pls find attached the file

Hi,

Am Fri, 28 Mar 2014 13:41:42 +0000 schrieb Moideen:

When i insert new row above current date (Eg. Row E10, Inserted New Row)
both rows are hightlighted, Please note When i inset new row below
current date it working fine

if you insert a row above the current date Excel creates a new
conditional format. Write your data below the table or delete the new
conditional format.


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional

Hi again,

Am Fri, 28 Mar 2014 13:41:42 +0000 schrieb Moideen:

When i insert new row above current date (Eg. Row E10, Inserted New Row)
both rows are hightlighted, Please note When i inset new row below
current date it working fine

please have another look for the workbook "Today" on OneDrive.
I changed the formula into the conditional formatting.

Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional