ExcelBanter - Conditional Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/139398-conditional-formatting.html)

colette

Conditional Formatting

How can I get a cell to automatically format when data is placed in an
adjacent cell.
--
Colette

Gary''s Student

Conditional Formatting

Yes...say we want B1 to display a background color once A1 has data in it.

Use Formula Is:

=$A$1<""

and then pick the format.
--
Gary''s Student - gsnu200716

"Colette" wrote:

How can I get a cell to automatically format when data is placed in an
adjacent cell.
--
Colette

All times are GMT +1. The time now is 02:43 AM.