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

Conditional formatting
How to clear formatting in excel - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum
Excel formula to change cell color without conditional formatting - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
Phone formatting software for pc - Download - File management

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.

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

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

one cell will turn green when the two other cells match

Conditional formating - apply on more cells

Similar discussions

Subscribe To Our Newsletter!