Highlight cell if another cell contains specific text
Closed
Abbi
-
10 Jun 2022 à 17:31
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 10 Jun 2022 à 20:21
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 10 Jun 2022 à 20:21
Related:
- Conditional formatting if cell contains text
- Excel conditional formatting if cell contains specific text - Best answers
- Excel conditional formatting if another cell contains specific text - Best answers
- How to use conditional format based on text? ✓ - Excel Forum
- Excel add 1 if cell contains text ✓ - Excel Forum
- Excel clear formatting - Guide
- Conditional formatting based on another cell text - Excel Forum
- Highlight cell if another cell contains any text ✓ - Excel Forum
1 response
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
10 Jun 2022 à 20:21
10 Jun 2022 à 20:21
Hello Abbi,
You could simply use Conditional Formatting to do the task for you:-
- Select cell C6 and go to the Home tab then go to the Styles group and select Conditional Formatting.
- Select New Rule.
- The 'New Formatting Rule' dialogue box will appear.
- Select 'Use a formula to determine which cells to format".
- In the text box under the heading 'Format values where this formula is true', type in the following formula:
=N6="Yes"
- Click OK on the 'Format' button. A Format Cells dialogue box will appear.
- Select the shade of green that you would like to use. Click OK.
- The 'New Formatting Rule' dialogue box should still be there. Click OK on this box as well.
The cell formatting for C6 should now be set to green when N6 says "Yes".
Repeat the above steps for the "No" and "n/a" criteria.
Cell C6 should be clear of any formatting if anything other than the required three criteria is used.
I hope that this helps.
Cheerio,
vcoolio.
You could simply use Conditional Formatting to do the task for you:-
- Select cell C6 and go to the Home tab then go to the Styles group and select Conditional Formatting.
- Select New Rule.
- The 'New Formatting Rule' dialogue box will appear.
- Select 'Use a formula to determine which cells to format".
- In the text box under the heading 'Format values where this formula is true', type in the following formula:
=N6="Yes"
- Click OK on the 'Format' button. A Format Cells dialogue box will appear.
- Select the shade of green that you would like to use. Click OK.
- The 'New Formatting Rule' dialogue box should still be there. Click OK on this box as well.
The cell formatting for C6 should now be set to green when N6 says "Yes".
Repeat the above steps for the "No" and "n/a" criteria.
Cell C6 should be clear of any formatting if anything other than the required three criteria is used.
I hope that this helps.
Cheerio,
vcoolio.
