Highlight cell if another cell contains any text
Solved/Closed
Hello,
I have been searching and found several discussions similar to this.
However none have them were exactly the same and I haven't found my answer yet.
Would appreciate it if someone could help.
In need C9 to fill out red if any text is entered in B9
I am sorry if this is already answered and I did not find it.
Many thanks in advance.
I have been searching and found several discussions similar to this.
However none have them were exactly the same and I haven't found my answer yet.
Would appreciate it if someone could help.
In need C9 to fill out red if any text is entered in B9
I am sorry if this is already answered and I did not find it.
Many thanks in advance.
Related:
- Excel if cell contains text
- Excel conditional formatting if cell contains specific text - Best answers
- Excel if contains - Best answers
- Excel add 1 if cell contains text ✓ - Excel Forum
- Excel conditional formatting if cell contains specific text - Excel Forum
- Excel mod apk for pc - Download - Spreadsheets
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 1, 2016 at 08:42 AM
Jul 1, 2016 at 08:42 AM
LvH, Good morning.
Try to use:
Select C9
Conditional Formating:
Formula:
=AND(ISTEXT(B9),ISNONTEXT(C9))
Choose the color RED for FILL COLOR.
Please, tell us if it worked for you.
I hope it helps.
Try to use:
Select C9
Conditional Formating:
Formula:
=AND(ISTEXT(B9),ISNONTEXT(C9))
Choose the color RED for FILL COLOR.
Please, tell us if it worked for you.
I hope it helps.
Jul 4, 2016 at 10:59 AM