Change format of a cell when another cell is not null [Closed]

Report
-
Posts
1921
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 13, 2021
-
How do I highlight a cell or row when another cell contains anything?

Thanks!

1 reply

Posts
1921
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 13, 2021
143
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!