conditional formatting

[CoasterKing70]

I have created a spreadsheet that has 27 columns (but, may add more) and the number of rows is undetermined but, may grow to more that 100 rows. I would like to use conditional formatting to change cell colors based on requirements. This spreadsheet is a shared workbook.
I have successfully created each conditional format that I want and all functions work until I make it a shared workbook. Once I save it as a shared workbook, the first couple of rows loose their conditional format and actually adds rows when typing in a cell.
What am I doing wrong. Thank you.

 

[etaf]

Once I save it as a shared workbook

how are you saving as a shared workbook ?

 

[CoasterKing70]

Tools-Share Workbook-Allow changes by more than one user...-ok-save

 

[etaf]

i have not used that feature of excel - i assume its 2003 as you refer to Tools

not sure why it would change , and do not have 2003 handy to try out , will try later