Previous Topic Next Topic

Conditional Formating: Duplicate value in range of cells

Closed
davidplowman Posts 5 Registration date Wednesday April 3, 2013 Status Member Last seen July 8, 2013 - Apr 3, 2013 at 01:05 PM
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 - Apr 4, 2013 at 12:21 AM
Hello:

Using Excel 2010, I'm trying to set up conditional formatting to see if a particular value in column A2 is equal to a value listed anywhere with a range of cells in a particular column (B2-B99). If so, I'd like it hightlighted in red. Then I want to go down column A and check the next, and so forth to the end of the column. (A2-A31).

Seems simple enough, but I'm new to both conditional formating and Excel 2010, so it looks like I need help. Any suggestions?

Thanks,
David

1 response

Answer 1 / 1
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
Apr 4, 2013 at 12:21 AM
Hi

Please Try this for B2:B99

Select the B2:B99 and select the Conditional Format select New Rule
then select the Format Cells that contain and Select Cell Value and select the Equal to in the Range option give the $A$2 and format as you like

and also for A2:A31 also

Hope it will clear if not please refer us


Thanks

Patnaik

Similar discussions

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

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

1 response
Conditional formatting several cells risk register
oyvinols -
fdibbins -

1 response
Applying conditional formatting rule to other rows
FrejaOlsen -
TrowaD -

1 response
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses