How to use conditional format based on text [Solved/Closed]
Leanne991
Posts Friday November 9, 2012Registration date
November 9, 2012
Last seen
-
Nov 9, 2012 at 05:28 AM - Latest reply: Mooseman
- Jan 24, 2018 at 01:39 PM
Hello,
I want a cell to change colour if another cell contains the words "first aid". The text comes down from a drop down list and could read "First Aid" or "sleepover/first aid". If the cell has "first aid" in it I want the other cell to change colour
I can get it to work if using formula f13=first aid but it won't change colour if the cell says sleepover/first aid?
specific word just use the formula [if the column your looking for is A and the reference is A2] =A2="word". Make sure it is relative formatting and copy it down.
its 2016 and this answer is still good! I used it to format cells that contained the word "Medium" but the look up was "Medium-8" through to "Medium-18" worked perfectly. Cheers Zohaib R :)
June 2017 - Thanks so much Zohaib, I was running in circles and wouldn't have thought of this (self taught, and I still don't understand its logic, but it works so I'm ecstatic!) ~K
Hi, I have 2 columns. I want to chenge the color of column B based on value in column A. If value in A is greater than or equal to zero, color should be green else red(I am doing this with conditional formatting and it works fine.)
Problem:
when the color is changing I want to add a text On track and color green or else delayed and color red. Is that possible?
Use the below mentioned steps to apply conditional formatting to the cells.
1. Select the cells where you want to apply the Conditional Formatting.
2. Click Conditional Formatting from the top ribbon.
3. Select New Rule.
4. Click Use a formula to determine which cells to format.
5. Enter the below mentioned formula in Format values where this formula is true:
=ISNUMBER(SEARCH("first aid",F13))=TRUE
6. You will all the cells which have the word "first aid" in it, the cells against them will be highlighted.
thank you so much for your reply. I am using Office 2011 for Mac. I have tried using and OR formula and this appears to be working although a little complex.
This is particularly helpful, but can it be extended to respond in other colours where the answer in F13 may not be "first aid", but something else like "health & safety"?
I have used AND Logical Operator to select three different criterion. Check if this helps.
If you need further assistance please post some more details about your datasheet. In addition, you can upload a sample file to: http://www.speedyshare.com/
Note: Before you upload any files please make sure there is no personal or confidential information contained in it.
I have two columns with different information. I want to be able to highlight certain information in both columns based off of the information entered. If Column E contains 38, 48, 55, 56, 58, 70 OR 713 and Colum C contains "service", then highlight both cells. I am on Office 2010.
