Previous Topic Next Topic

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 responses

Answer 1 / 2
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
Answer 2 / 2
Matheswaran
Mar 19, 2013 at 01:42 AM
Hi Zohaib,

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

Regards,
Matheswaran
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses