So I've been looking all over online trying to find a way to do this, but basically I have a cell that needs to turn red if it contains a specific text, and if another cell contains a different specific test.
If column D says "CD" and column E says "Frag" I need column E to appear red. Any help would be really appreciated. Thanks!
Bookmarks