How can I get a cell to automatically format when data is placed in an adjacent cell.
C Colette Apr 18, 2007 #1 How can I get a cell to automatically format when data is placed in an adjacent cell.
G Gary''s Student Apr 18, 2007 #2 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.
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.
