I want to write a formula that checks a cell for a specific string. If the string is in the cell then it needs to apply a background color to a range of cells.
I have written formulas in the past that included [color], e.g., [Red] or [Blue] in it and it will apply that background color. If someone could please provide me the syntax for applying colors in a formula, I would greately appreciate it.
Thanks,
Hi, you can use conditional formulas for this.
For example, A1 contains the text "Mary had a little lamb"
You want B1 to D1 to turn green if A1 contains the text "had"
Select B1 to D1 and on the Format menu select "Conditional Formatting"
Select "Formula Is" and in the condition box enter this formula:
=FIND("had",$A$1)>0
Format the colouring that you want to apply for this condition.
Done.
HTH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks