Change format of a cell when another cell is not null
Closed
klor
-
6 Sep 2016 à 01:11
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 6 Sep 2016 à 10:31
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 6 Sep 2016 à 10:31
Related:
- Modify the format of the selected cell
- Clear only the formatting from the selected cell - Guide
- Dvi format - Guide
- Kingston format utility - Download - Storage
- Hdd low level format tool - Download - Storage
- How to change the date format in excel - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
6 Sep 2016 à 10:31
6 Sep 2016 à 10:31
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
