LinkBack URL
About LinkBacks
EDIT>>>> I am using Excel 2002.
How to I set conditional format to colour a cell yellow if the word EAGLES appears in it?
Thanks.
EDIT>>>> I am using Excel 2002.
How to I set conditional format to colour a cell yellow if the word EAGLES appears in it?
Thanks.
Last edited by deltech; 09-21-2012 at 12:01 PM.
Conditional Eagle.jpg
Select the cells you want to format, click conditional formatting, add new rule.
Format only cells that contain
Choose Specific Text, containing, type Eagle, and then click format, and choose background yellow.
See attached
<---- If this helped you please click the star!
http://excelevangelist.blogspot.com/
under CF, set to formula (not cell) and use this formula...
=ISNUMBER(FIND("eagle",A1,1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Doesn't work....Originally Posted by FDibbins
Use "Search" instead of FIND. FIND is case sensitive. SEARCH is not
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
thanks ChemistB, good catch
de nada
Works a treat. Many thanks.
@ deltech
Welcome to the forum.
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Sorry cutter.
Last edited by Cutter; 09-22-2012 at 12:10 PM. Reason: Removed whole post quote
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks