I am creating a Template and need a little help.
I have the data entry area set up as a list and have set up the following
conditional format to shade every other row =MOD(SUBTOTAL(3,$A$4:$A4),2)=0
This conditional format is only applied to the data area (columns A through
N), not to the entire row.
When I go to the blue asterisk and enter 2 new records, the conditional
format only carries down in columns M and N. Those two columns have
formulas...columns A through L are data entry.
Any idea how to correct this so the conditional format formula correctly
carries down for the entire applied area (A:N)? I have been resetting the
conditional format formulas for an hour now to make sure they apply to the
entire data area, but it's not working. I even have 4 starter rows with fake
data to help Excel understand that this needs to carry down, but nothing
works.
Thank you!!!