Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-25-2014, 06:31 PM
Friedtater22 Friedtater22 is offline Having a conditional formatting migraine. Please Help! Windows 7 64bit Having a conditional formatting migraine. Please Help! Office 2010 64bit
Novice
Having a conditional formatting migraine. Please Help!
 
Join Date: Apr 2014
Posts: 1
Friedtater22 is on a distinguished road
Exclamation Having a conditional formatting migraine. Please Help!

I'm trying to use conditional highlighting to highlight cells B3:O3 based on certain text that is in J3. I have figured out everything except for the formula to use for specific text followed by variable text. What I need is when J3 says "moved to" followed by a location, the row should be highlighted. I found online somewhere that I could use the formula "=$J3=ISNUMBER(SEARCH("MOVED TO",J3))=TRUE", but that doesn't work for me. For some reason, it highlights the row without anything being in J3. When I change the formula to "=FALSE), that doesn't work either. When FALSE is used, anything and everything that gets put into J3 highlights the row. My worksheet is A1:O27, with the headers being in rows 1 and 2. Data starts in B3. I need this to work in each row from B3:O27. PLEASE HELP!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting teza2k06 Excel 3 01-19-2014 02:34 AM
conditional formatting otuatail Excel 1 06-06-2012 05:07 AM
Conditional formatting zanat0s Excel 4 01-20-2012 03:30 AM
Having a conditional formatting migraine. Please Help! Conditional formatting with AND, OR Lucky Excel 2 10-03-2011 11:41 PM
Having a conditional formatting migraine. Please Help! Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft