I want to highlight all cells in a row, when one of the cells in that row has the word "completed" in it. How can I do this?
I want to highlight all cells in a row, when one of the cells in that row has the word "completed" in it. How can I do this?
1. Highlight the range you want to use
2. On Home tab, select CD
3. Select New Rule, select Use Formula
4. =$A1="completed"
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
Is this for Word or for Excel? Ford's advice applies to Excel but you've posted in the Board's Word forum.
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Good catch Paul, did not even notice that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks