Start with a Blank worksheet.
In A1 start, with NO formatting
A B SUM
1 2 3 (the SUM column contains the formula (=A2+B2)
Conditional Format for all three columns to turn green if =$C2>0, and red if =$C2<0. The cells will therefore be clear/white if $C2=0.
Everything works great.
Lets do an autofill and and a nother row. Everthing is still great.
A B SUM
1 2 3 (the SUM column contains the formula (=A2+B2)
1 2 3
Now, I perform a "Create List..." from the Data menu.
Select A1 thru C3 and "My table has headers"...
Start entering data in the "Insert Row" of the List.
Everything still works great.
Now, select the all the cells in the table/list and add full borders.
Start entering data in the "Insert Row" of the List again.
The Conditional formatting does not automatically copy down anymore in columns A and B - ONLY C.
WHY?
In A1 start, with NO formatting
A B SUM
1 2 3 (the SUM column contains the formula (=A2+B2)
Conditional Format for all three columns to turn green if =$C2>0, and red if =$C2<0. The cells will therefore be clear/white if $C2=0.
Everything works great.
Lets do an autofill and and a nother row. Everthing is still great.
A B SUM
1 2 3 (the SUM column contains the formula (=A2+B2)
1 2 3
Now, I perform a "Create List..." from the Data menu.
Select A1 thru C3 and "My table has headers"...
Start entering data in the "Insert Row" of the List.
Everything still works great.
Now, select the all the cells in the table/list and add full borders.
Start entering data in the "Insert Row" of the List again.
The Conditional formatting does not automatically copy down anymore in columns A and B - ONLY C.
WHY?
