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 Contributor Last seen December 27, 2022 - Apr 25, 2017 at 11:37 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Apr 25, 2017 at 11:37 AM
Related:
- Conditional formatting based on column of values
- Excel conditional formatting based on date - Guide
- Conditional formatting if cell contains text ✓ - Excel Forum
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Instagram account based in wrong country - Instagram Forum
- How to clear formatting in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
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