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

Question

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

Report

klor - Sep 6, 2016 at 01:11 AM
Mazzaropi

Posts: 1921
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: May 13, 2021

- Sep 6, 2016 at 10:31 AM

How do I highlight a cell or row when another cell contains anything?

Thanks!

Change format of a cell when another cell is not null
Cannot change format of cells in excel ✓ - 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
Conditional formatting if another cell contains any text ✓ - Forum - Excel
Excel click on cell to change value of another cell - Forum - Excel

1 reply

Ask a question

Mazzaropi · Answer 1 · 2016-09-06T10:31:01-0400

Answer 1 / 1

Mazzaropi

Posts: 1921
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: May 13, 2021

143
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

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

1 reply

Your reply

Subscribe To Our Newsletter!