Change format of a cell when another cell is not null

Closed
klor - Sep 6, 2016 at 01:11 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Sep 6, 2016 at 10:31 AM
How do I highlight a cell or row when another cell contains anything?

Thanks!

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
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
0