Conditional formatting

[Solved/Closed]
Report
Posts
1
Registration date
Monday March 18, 2013
Status
Member
Last seen
March 18, 2013
-
 Matheswaran -
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

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
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.
Hi Zohaib,

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

Regards,
Matheswaran