Excel inverse search or find

		Microsoft Office Forums > Microsoft Excel > Excel
Excel inverse search or find

05-03-2021, 10:03 AM

jeffreybrown jeffreybrown is offline

Windows 10 Excel inverse search or find

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inverse Grayscale in Slideshow mode	esersen	PowerPoint	1	06-29-2014 11:19 PM
Find what box in Find and replace limits the length of a search term	Hoxton118	Word VBA	7	06-10-2014 05:05 AM
How to obtain the inverse tan of a value in degree/minute second?	Jamal NUMAN	Excel	3	07-27-2013 10:18 AM
Won't find in search	ep2002	Word	3	10-31-2012 05:24 PM
How to get the inverse of the values in the same table?	Jamal NUMAN	Excel	4	04-16-2011 06:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 AM.