Calculating conditional values.

[jlokesh16]

I have an database of 1000-1100 records. I want to select few records which are constant and need to be highlighted in red color text whenever i paste all the records in column A. I want to know how can i select the highlights and as they are constant, how can i recall them daily in an different sheet when i update the master list.

 

[Yongle]

This is my interpretation of what you have written

I want to specify certain records in the database ...
How about adding a column (cloumn X) and flagging each record ?

Whenever I paste data into column A on another sheet, I want those items that match XXX to be highlighted in red on that sheet (not in the database)
how about this as the conditional formatting condition?
=(COUNTIFS(DataBase!A:A,OtherSheet!A2,DataBase!X:X,"FLAG"))>0

Also I want to see those items separately listed on a separate sheet
do you simply want the day's RED rows listed on separate sheet?

 

[jlokesh16]

Yes, column A is constant, so if i enter the data, i need the highlighted one in col B, or a new sheet.

 

[Yongle]

Did you try my first 2 suggestions?