nos402
New member
- Joined
- Jan 23, 2013
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hoping someone can solve this mystery for me. I have 2 spreadsheets. They both have identical conditional formatting that changes the color of column A and B based on what is entered in B. I am using Excel 2010.
View attachment test.xlsx
On this one, if you type "pass" in column B, A and B turn green but A loses the indention.
If you select "pass" from the drop down menu in B instead, it retains it's indention (and all other cells that have been conditionally formatted will also regain their indention).
As soon as you press enter or delete anywhere in the sheet, all Conditionally formatted cells lose their indention again.
View attachment test2.xlsx
This spreadsheet works perfectly. Conditional formatting works and indentions remain. I can not find any differences between the two that are causing this.
The only thing I can think of is that the first one started as an Excel sheet, was uploaded to Google docs, and then later downloaded as an Excel sheet again. This is so frustrating!
View attachment test.xlsx
On this one, if you type "pass" in column B, A and B turn green but A loses the indention.
If you select "pass" from the drop down menu in B instead, it retains it's indention (and all other cells that have been conditionally formatted will also regain their indention).
As soon as you press enter or delete anywhere in the sheet, all Conditionally formatted cells lose their indention again.
View attachment test2.xlsx
This spreadsheet works perfectly. Conditional formatting works and indentions remain. I can not find any differences between the two that are causing this.
The only thing I can think of is that the first one started as an Excel sheet, was uploaded to Google docs, and then later downloaded as an Excel sheet again. This is so frustrating!