hello, i want creat a macro that find new entrys between two sheets, here i
am trying to explain.

Sheet1 my range is E1:E5000 like 1,2,3,4,5.....
Sheet2 range is A1:A5000 like 1,2,3,4,5,6,8,9,10.... now here few new entrys
are 6,8,9 & 10.....
are there anyway to catch new entrys like back ground color or font color
would be changed with use a macro or other any ways to findout.
thanks in advance.

Hi Tunail,

There are two issues he

(1) Identifying the Column A values which are not present in Column E

See Chip Pearson's Duplicate page at:

http://www.cpearson.com/excel/duplic...gingDuplicates

See particularly the section entitled:

'Extracting Values On One List And Not Another'


(2) Collouring the non duplicated new value cells.

Use conditional formatting and employ the formula resuls obtained from
Chip's formulas (see item 1) as the CF criterion.

If you are not familiar with Conditional Formatting, see Debra Dalgleish's
tutorial at:

http://www.contextures.com/xlCondFormat01.html

---
Regards,
Norman


"Tufail" wrote in message
...
hello, i want creat a macro that find new entrys between two sheets, here
i
am trying to explain.

Sheet1 my range is E1:E5000 like 1,2,3,4,5.....
Sheet2 range is A1:A5000 like 1,2,3,4,5,6,8,9,10.... now here few new
entrys
are 6,8,9 & 10.....
are there anyway to catch new entrys like back ground color or font color
would be changed with use a macro or other any ways to findout.
thanks in advance.

thank you very much for your kind help, have a nice day/night (i think there
is night time but i am in Tokyo)

"Norman Jones" wrote:

Hi Tunail,

There are two issues he

(1) Identifying the Column A values which are not present in Column E

See Chip Pearson's Duplicate page at:

http://www.cpearson.com/excel/duplic...gingDuplicates

See particularly the section entitled:

'Extracting Values On One List And Not Another'


(2) Collouring the non duplicated new value cells.

Use conditional formatting and employ the formula resuls obtained from
Chip's formulas (see item 1) as the CF criterion.

If you are not familiar with Conditional Formatting, see Debra Dalgleish's
tutorial at:

http://www.contextures.com/xlCondFormat01.html

---
Regards,
Norman


"Tufail" wrote in message
...
hello, i want creat a macro that find new entrys between two sheets, here
i
am trying to explain.

Sheet1 my range is E1:E5000 like 1,2,3,4,5.....
Sheet2 range is A1:A5000 like 1,2,3,4,5,6,8,9,10.... now here few new
entrys
are 6,8,9 & 10.....
are there anyway to catch new entrys like back ground color or font color
would be changed with use a macro or other any ways to findout.
thanks in advance.