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