Conditional formatting based on column of values
Closed
Sivanesan
-
Apr 14, 2017 at 04:57 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Apr 25, 2017 at 11:37 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Apr 25, 2017 at 11:37 AM
Related:
- Conditional formatting based on column of values
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- Two values to find on the same cell ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Apr 25, 2017 at 11:37 AM
Apr 25, 2017 at 11:37 AM
Hi Sivanesan,
Select your range (when I pasted your data I got range A1:C11) and apply conditional format. Choose to use a formula:
=COUNTIF($C$1:$C$11,RIGHT($B1,4))
Best regards,
Trowa
Select your range (when I pasted your data I got range A1:C11) and apply conditional format. Choose to use a formula:
=COUNTIF($C$1:$C$11,RIGHT($B1,4))
Best regards,
Trowa