Previous Topic Next Topic

Highlight cell if another cell contains any text

Solved/Closed
LvH - 28 Jun 2016 à 07:03
 LvH - 4 Jul 2016 à 10:59
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.
Related:

2 responses

Réponse 1 / 2
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
1 Jul 2016 à 08:42
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
4 Jul 2016 à 10:59
Mazzaropi, thank you once again for you help.

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional formatting: change fontcolor based on another cell
wandanuila -
Ravi -

18 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
Excel: If Date =, then enter a value
JerrySD -
BrianGreen -

4 responses