Excel conditional formatting [Closed]

Report
Posts
3
Registration date
Tuesday May 30, 2017
Status
Member
Last seen
May 30, 2017
-
Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
-
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

Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
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
Posts
3
Registration date
Tuesday May 30, 2017
Status
Member
Last seen
May 30, 2017

What if B3 is a specific number? then change the color
Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
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
Posts
3
Registration date
Tuesday May 30, 2017
Status
Member
Last seen
May 30, 2017

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
Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
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