Thread: [Solved] Excel inverse search or find
View Single Post
 
Old 05-03-2021, 10:09 AM
Kevin@Radstock Kevin@Radstock is offline Windows 10 Office 2019
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi

=RIGHT($B4,3)<>"mp3" & copy down.

Use in conditional formatting to highlight B8 (in red), select range B4:B9

Home > Conditional Formatting > New rule > Use a formula to determine which cells to format > In the "Format values where this formula is true:" enter the formula above > format > your requirements.
Reply With Quote