Highlight the Row

[Moideen]

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

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

+-------------------------------------------------------------------
|Filename: Highlight.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=948
+-------------------------------------------------------------------

 

[Claus Busch]

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.

 

[Moideen]

Hi,

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

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.

Dear Sir,

Where can i enter this formula, please explai

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Claus Busch]

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.

 

[Moideen]

Hi again,

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

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.

Sir,

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

+-------------------------------------------------------------------
|Filename: F.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=961
+-------------------------------------------------------------------

 

[Claus Busch]

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 here:
https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "Today"


Regards
Claus B.

 

[Moideen]

Hi,

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

please look he
http://tinyurl.com/n9s5tdh
for the workbook "Today"


Regards
Claus B.

Thank You Very Muc

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Moideen]

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 belo
current date it working fine, pls do the needful, pls find attached th
fil

+-------------------------------------------------------------------
|Filename: FFF.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=962
+-------------------------------------------------------------------

 

[Claus Busch]

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.

 

[Claus Busch]

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.