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 54 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 - Apr 4, 2013 at 12:21 AM
sgmpatnaik Posts 54 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 - Apr 4, 2013 at 12:21 AM
Related:
- Conditional Formating: Duplicate value in range of cells
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- How to change date format in excel - Guide
1 reply
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
45
Apr 4, 2013 at 12:21 AM
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
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