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!
Helpful
+0
plus moins
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
Helpful
+0
plus moins
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
Helpful
+0
plus moins
Hi!

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A seozavtra.ru membership gives you access to additional options.