Formatting cell
Solved/Closed
Related:
- Formatting cell
- Clear only the formatting from the selected cell (leaving the content) - Guide
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Phone formatting software for pc - Download - File management
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
