Formatting cell [Solved]

sheeba - Nov 21, 2017 at 12:15 AM - Latest reply:  sheeba
- Nov 21, 2017 at 11:23 PM
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!
See more 

3 replies

Reply to this topic
Mazzaropi 1695 Posts Monday August 16, 2010Registration dateContributorStatus January 19, 2018 Last seen - Nov 21, 2017 at 07:01 AM
0
Helpful
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
Respond to Mazzaropi
Mazzaropi 1695 Posts Monday August 16, 2010Registration dateContributorStatus January 19, 2018 Last seen - Nov 21, 2017 at 07:04 AM
0
Helpful
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
Respond to Mazzaropi
0
Helpful
Hi!

Merci beaucoup.
Cela fonctionne et c'est tellement utile.
Respond to sheeba