Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do i change the cell background color in excel?
need more than 2 different colors depending on the text in the cell.
is there any way i can create a user defined function to dynamically change the cell color depending on text? not numerical value, text.
2 Answers
- 6 years ago
Let's say the cells contain "Yes" or "No".
1. Select the cells, select 'Conditional Formatting', 'Highlight Cell Rules', 'Text that contains...'.
2. In the box type Yes, and choose the format you want. Click OK
Repeat 1. above. Now, in the box type No, and choose a format. Click OK
Conditional Formatting can be far more complicated than this. I've just given you a basic to answer your question.
