Change format of a cell when another cell is not null
Closed
klor
-
Sep 6, 2016 at 01:11 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 6, 2016 at 10:31 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 6, 2016 at 10:31 AM
Related:
- Change format of a cell when another cell is not null
- How to change date format in excel - Guide
- Format factory - Download - Other
- Change computer name cmd - Guide
- Change name of lg tv - Guide
- How to change number of best friends on snapchat - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 6, 2016 at 10:31 AM
Sep 6, 2016 at 10:31 AM
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
