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,
Bookmarks