Conditional Formating: Duplicate value in range of cells
Closed
davidplowman
sgmpatnaik
- Posts
- 5
- Registration date
- Wednesday April 3, 2013
- Status
- Member
- Last seen
- July 8, 2013
sgmpatnaik
- Posts
- 54
- Registration date
- Tuesday April 2, 2013
- Status
- Member
- Last seen
- November 27, 2013
Related:
- Conditional Formating: Duplicate value in range of cells
- Excel conditional formatting based on date in another cell - Guide
- Conditional formatting: change fontcolor based on another cell ✓ - Forum - Excel
- Conditional Formatting Based on Data in another Cell ✓ - Forum - Excel
- Excel conditional formatting based on text in another cell ✓ - Forum - Excel
- Conditional Formatting range of date cells based on another cell ✓ - Forum - Excel
1 reply
sgmpatnaik
Apr 4, 2013 at 12:21 AM
- Posts
- 54
- Registration date
- Tuesday April 2, 2013
- Status
- Member
- Last seen
- November 27, 2013
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