Conditional Formatting

Closed
Chris172
Posts
1
Registration date
Sunday May 7, 2017
Status
Member
Last seen
May 7, 2017
- May 7, 2017 at 08:42 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- May 7, 2017 at 09:09 AM
Hello,
I am trying to change a text color of one column based on another columns value. For example in Column A if it shows a W then the Dollar amount in Column B will be red. Can you help me?

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
May 7, 2017 at 09:09 AM
Chris172, Good morning.

Select cells at colunm B to apply the CF.

Suppose: B2:B100
Menu Conditional Format
Using Formula
=A1="W"

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