Formatting not updating
I have an excel file that has been exported from a SQL Server Reporting Services report.
The cells in the first column are a list of store numbers and should all be center aligned but for some reason a few of them are left aligned.
When I go to correct the alignment by setting it to center nothing happens.
When I go and change the column type from General to Number to Text still nothing happens.
However, when the column is set to Text and then I go edit (F2 then 'enter') the cell it magically aligns back to the middle.
Next I highlighted all the same cells with numbers in them, then on the Home ribbon bar, under the number section, I chose the drop down which was showing text and changed it to number.The centring remained and the cells were now being treated as a number again.Update: I want one specific cell to become green (filled with green color) if a range of other cells (which contain only dates) count up to 7 or more filled cells AND contain dates within a specific date range.I have created a logical function which is but as soon as I want to use it for the conditional formatting the color labeling doesn't work.Is there a specific reason why the following formula works (=becoming true) in a cell but not in the conditional formatting?I have a feeling that it is related to the DATE range filter but don't know exactly.Example sheet: https://docs.google.com/spreadsheets/d/1u H2PZ9Ym FNQDmml73i KQNz6sv8t Ewb ETRo0ywxz6yg4/edit?usp=sharing Update: I want one specific cell to become green (filled with green color) if a range of other cells (which contain only dates) count up to 7 or more filled cells AND contain dates within a specific date range.I found a weird bug when using Excel conditional formatting.I made a Excel report that is transformed to a PDF document.When i preview the document in Excel the conditional formatting is used and shown It's a simple conditional formatting rule.