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