Excel conditional formatting

Closed
hredding Posts 3 Registration date Tuesday May 30, 2017 Status Member Last seen May 30, 2017 - May 30, 2017 at 02:47 PM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - May 31, 2017 at 09:28 AM
How do change the color of one cell if another cell contains a text. For example: If B3 contains any text then I want A3 to change color.

3 replies

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
May 30, 2017 at 03:40 PM
hredding, Good afternoon.

Select A3 to apply the CF.

Menu Conditional Format
Using Formula
=ISTEXT(B3)

Select colour format as desired
OK

Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
hredding Posts 3 Registration date Tuesday May 30, 2017 Status Member Last seen May 30, 2017
May 30, 2017 at 03:54 PM
What if B3 is a specific number? then change the color
0
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
May 30, 2017 at 04:33 PM
hredding,

Try to use:

If you want to check a number 4 -->

=B3=4

I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
hredding Posts 3 Registration date Tuesday May 30, 2017 Status Member Last seen May 30, 2017
May 30, 2017 at 04:54 PM
Very helpful. Thank you. One more question...

What if I want a cell to display a number if another cell contains a specific word?

For example, if B3 contains the word "meets" then I want C3 to display a number 3
0
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
May 31, 2017 at 09:28 AM
hredding, Good morning.

This new question does not apply to the case of conditional formatting that deals only with aesthetic cell characteristics.

To do what you need, you must use the IF function.

Try to use:

C3 --> =IF(B3="meets", 3, "")

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0