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

LvH - Jun 28, 2016 at 07:03 AM - 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 

4 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jul 1, 2016 at 08:42 AM
1
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.

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1894 users this month

Mazzaropi, thank you once again for you help.
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jun 28, 2016 at 12:30 PM
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