Report

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

Ask a question LvH - Last answered on Jul 4, 2016 at 10:59 AM by 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.
Helpful
+1
plus moins
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.
Was this answer helpful?  
LvH- Jul 4, 2016 at 10:59 AM
Mazzaropi, thank you once again for you help.
Helpful
+0
plus moins
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 at 06:06 AM
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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!