Report

Highlight cell if another cell contains any text [Solved]

Ask a question LvH - Latest answer on Jul 4, 2016 10:59AM
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 
Helpful
+1
moins plus
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.
LvH- Jul 4, 2016 10:59AM
Mazzaropi, thank you once again for you help.
Reply
Add comment
Helpful
+0
moins plus
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.
LvH- Jul 1, 2016 06:06AM
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
Reply
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!