Highlight cell if another cell contains any text [Solved/Closed]

- - Latest reply:  LvH - Jul 4, 2016 at 10:59 AM
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.
See more 

2 replies

Best answer
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
130
3
Thank you
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.

Say "Thank you" 3

A few words of thanks would be greatly appreciated. Add comment

CCM 6319 users have said thank you to us this month

Mazzaropi, thank you once again for you help.
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
130
0
Thank you
LvH, good afternoon.

Try to use:

Select C9

Conditional Formating:
Formula:
=ISTEXT(B9)

Choose the color RED for FILL COLOR.

Please, tell us if it worked for you.
I hope it helps.
Thank you Mazzaropi, this works.
However this was only half of the challenge I have.
Now when text is entered in B9, C9 will fill up red, however when text is then entered in C9 it should return white again.


Looking forward to the answer