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

Report
-
 LvH -
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.

2 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 16, 2020
135
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.
3
Thank you

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

CCM 2773 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
September 16, 2020
135
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