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 December 27, 2022 - Apr 25, 2017 at 11:37 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 25, 2017 at 11:37 AM
Related:
- Conditional formatting based on column of values
- Based on the values in cells b77 ✓ - Excel Forum
- Instagram account based in wrong country - Instagram Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history ✓ - Facebook Forum
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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