Conditional formatting

matheshphy Posts 1 Registration date Monday March 18, 2013 Status Member Last seen March 18, 2013 - Mar 18, 2013 at 04:06 AM
 Matheswaran - Mar 19, 2013 at 01:42 AM

I need a help on Conditional formatting:

I have a data in A2:E5 (Sheet 1), and in Sheet 2 i have reference data in Column A.
i need to highlight the cells in the range A2:E5 (Sheet 1) which has the same value in Sheet 2 Column A.

I am not able to select the reference range in Conditional formatting

Help me. Thank you in advance

2 responses

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 18, 2013 at 04:12 PM
Hi matheshphy,

Please use this formula in "Conditional Format":

=AND(A2<>"", NOT(ISERROR(MATCH(A2,Sheet2!$A:$A,0))))

I have uploaded the sample file below for your help:

Do reply with results.
Hi Zohaib,

Thanks it was a timely help and it saves my time.