Thread: [Solved] Excel inverse search or find
View Single Post
 
Old 05-03-2021, 10:03 AM
jeffreybrown jeffreybrown is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

The easiest way would be to apply conditional formatting.

Conditional Formatting
  • Highlight applicable range >> B4:B9
  • Home Tab >> Styles >> Conditional Formatting >> New Rule
  • Select a Rule Type: Use a formula to determine which cells to format
  • Edit the Rule Description: Format values where this formula is true: =RIGHT(B4,3)<>"mp3"
  • Format… [Number, Font, Border, Fill]
  • OK >> OK
Reply With Quote