![]() ![]() The final result was all my CFs worked properly and didn't change the font! ![]() ![]() Finally, I deleted the old worksheet, with the new, essentially identical one, in its place. Also, I redid any CFs I originally needed. Then, I copied and pasted any borders, text, formulas, etc. This led me to believe that the desired behavior COULD be achieved. I noticed the conditional formatting formulas in one worksheet undesirably changed the font, while the other worksheet left it alone. My setup: I am currently working with Excel 2010 with a. xlsx would work, but some of us, myself included, have to support Excel 2003 users. That would be livable if it weren't for that fact that MS DOES change it. So, you can't do it because MS doesn't trust you with it. Why Conditional Formatting is disabled: To expand on one of rajah9's comments, the reason you can't change font in Conditional Formatting is discussed here where it says: It's not clean and exact and I can't explain it, but it worked for me. Thanks to this question (and the discussions in it), some other research, and some random stabbing in the dark, I came to a 'solution'. I recommend that you save it to Excel 2007 format (.xlsx) and see if the conditional formatting works better. xlsx format? The inconsistent spreadsheet behavior you observe may be caused because Excel is trying to preserve Excel 2003 behavior. Have you been saving the spreadsheets in. You mentioned that these were Excel 2003 spreadsheets that you are working with in Excel 2007. You can underline it or turn it red, but it seems like Excel won't let you make it a 40 point Haettenschweiler. I don't think this is a bug, but rather a more subtle way to encourage you to make better font choices. I later went back and changed the regular formatting of the cells so that they were all Arial 12 point. I conditionally formatted the cells so that it turned red if the cell equals 10. the font style (regular/italic/bold/bold italic).I have conditionally formatted some cells, and I have observed the behavior you describe. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |