Change format of a cell when another cell is not null
[Closed]
Report
klor
-
Mazzaropi
Mazzaropi
- Posts
- 1943
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- September 22, 2021
Related:
- Change format of a cell when another cell is not null
- How to change date format in excel cell - How-To - Excel
- Cannot change format of cells in excel ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
- How to change value based on cell color in excel ✓ - Forum - Office Software
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
1 reply
Mazzaropi
- Posts
- 1943
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- September 22, 2021
Klor, Good morning.
Your request is very superficial.
Missing data to help you effectively.
Suppose you want color cells B1:F1, IF A1 is not empty.
Try to do:
Select cells you want color: B1:F1
CF MENU --> NEW RULE --> USING FORMULA
Type it at field: =$A$1<>""
Choose ORANGE as fill format
OK
Please, tell us if it works for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Your request is very superficial.
Missing data to help you effectively.
Suppose you want color cells B1:F1, IF A1 is not empty.
Try to do:
Select cells you want color: B1:F1
CF MENU --> NEW RULE --> USING FORMULA
Type it at field: =$A$1<>""
Choose ORANGE as fill format
OK
Please, tell us if it works for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
