Conditional formatting

Solved/Closed
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
Hello,

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 replies

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:

http://speedy.sh/7P9ct/ValueReference.xlsx

Do reply with results.
0
Hi Zohaib,

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

Regards,
Matheswaran
0