Background Cell Colour-If Data Match
Create an Excel defined name for the range on Sheet2, say s2data, and then
use Conditional Formatting on the range on Sheet1 with a formula of =ISNUMBER(MATCH(A1,s2Data,0)) and set the colour to suit. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Vadhimoo" wrote in message ... Hi , I am having two sheets like: Sheet1: John Michael Legault David ....... Sheet2: David Eric John Dave ....... Here i want to compare the Sheet1 's data with Sheets2's data. If the data match, i want to set the background color(yellow or red) for those datas in the Sheet1. Result: Sheet1: John(Set Background Color) Michael Legault David(Set Backlground Color) ....... Thanks and Regards, Vadhimoo |
All times are GMT +1. The time now is 07:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com