Formatting cell [Solved/Closed]

Report
-
 sheeba -
Hello,

I want to highlight the coloumn B, if the coloumn A is greater than 0, In column A having numbers and the column B having texts. here some below Ex:

0 Jody Stewart
490 Paul Hayler
0 pamela beedleston
0 edem
520 Linda Green
0 Nick
55 Megan Povey




Thank You!

4 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
sheeba, Good afternoon.

Suppose:
A1:A100 --> Numbers
B1:B100 --> Names

Try to use:
a) Select B1:B100

b) Conditional Format --> Using formula
--> =A1>0
--> Format: Fill color as wanted.
OK

Please, tell us if it worked as you desired.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
131
sheeba, Good afternoon.

Suppose:
A1:A100 --> Numbers
B1:B100 --> Text

Try to use:
a) Select B1:B100

b) Conditional Format --> Using formula
--> =A1>0
--> Format: Fill color as needed
OK

Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Hi!

Merci beaucoup.
Cela fonctionne et c'est tellement utile.