Color Cell

[vijay2482]

i have a worksheet "ComparedExcel" in workbook "workbook1".
in the comparedExcel worksheet, i have compared 2 other worksheets and entered the cell values that r different with red color in this format "AAA<>BBB"

in workbook2 "ECN_Modele_bh" i have a worksheet named "ECN".
i have divided the worksheet into 2 parts as current and new.
in the current part i will enter the values of the cell from worksheet "Ariane" in workbook1 and in the new part i will enter the value of the cell from worksheet "Intralink".

upto this i have the correct output.

now what i want to do is,
color the cell in red in current with different value corresponding to the cell in new and color the cell in green with different value corresponding to the cell in current.

eg:<!-- BEGIN TEMPLATE: bbcode_html -->
HTML Code:

current                          new
cell1 cell2                cell4 cell5 
DDD   AAA                 DDD         BBB

</PRE>
<!-- END TEMPLATE: bbcode_html -->i want to color the entire cell2 in red and cell5 in green and not the values.
here in my post,the colors are used in the text/value


thanks in advance <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->