Formatting cell
Solved/Closed
Related:
- Insert a function in cell b2 to display the current date from your system.
- How to insert at the rate in laptop - Guide
- Insert check mark in word - Guide
- How to insert photo in word for resume - Guide
- Where is the insert key on a laptop - Guide
- Mutator function c++ - Guide
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 21, 2017 at 07:01 AM
Nov 21, 2017 at 07:01 AM
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 21, 2017 at 07:04 AM
Nov 21, 2017 at 07:04 AM
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
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
