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