I have a standard form I use that requires an row to be highlighted one of 7 colors when a condition is met in a cell in that row.  The form varies wildly in length.  Currently, I am using conditional formatting for this behavior.  However, every time I delete or add rows, it breaks apart the conditional formatting into 2 pieces.  This causes some issues and "managing the rules" is pretty time consuming.  One thought I had would be to keep the formatting on another sheet in the workbook that I do not edit, and then applying it at the end, if that is possible.  Has anyone found a work around for this?  Is this kind of entire row formatting with color based on one cell possible in a way that does not require conditional formatting?
I have the following annoying problem with Excel 2010. I use Conditional formatting to apply bold formatting to each line of the spreadsheet that meets a condition expressed by a formula. In the "applies to", I write =$A$2:$Q$149, which is the current extent of my spreadsheet. But I want this range to grow with my spreadsheet, i.e., I want the formatting to permanently apply to the whole spreadsheet. Regularly, my "applies to" field is transformed into a complex range, that selects most lines of spreadsheet, but not all, like =$A$2:$Q$138;$A$140:$Q$147. Have you ever encountered such a problem? Is there a solution?
If I pay off lease amount early for a car, is there any impact on my credit?  Let's say I'm paying $400/month for 36 months, which is 14,400 total. If I pay 14,400 within 6 months, are there any disadvantages on my credit? Dispose or Recycle Hard Drive I have 3 old 3.5" internal hard drives sitting gathering dust at the moment. 2 are SATA, and one IDE. I want to either start putting them to use, or dispose of them to clear up some space.  What is the best approach towards disposing of the drives in terms of thoroughly cleaning the contents before throwing away or selling? Are there any recommendations for good software to use to do this?   Are there any 100% successful methods which result in having a usable drive at the end? horizontal alignment of dot over hat over bold greek letter! For some strange reason, this:   \hat{\dot{\bm{\phi}}}   prints the dot and the hat slightly off the left of the phi letter. Any ideas if this can be fixed? thanks. Using bm package for bold symbols. As you can see from the image below, I have an issue with the text alignment of extra long chapter names. How can I fix it so that the text will not go further left than the start of the chapter name? That is, I don't want any text to be underneath the "Appendix A" part.  I added that red line just to show how I'd like it aligned, if possible.    Here's my MWE:  \documentclass{book} \let\cleardoublepage\clearpage  \RequirePackage{titletoc} \RequirePackage{tikz} \RequirePackage[explicit]{titlesec} \RequirePackage{DejaVuSansCondensed} \RequirePackage[normalem]{ulem} \RequirePackage[   left=2.25in,   right=0.75in,   top=1.25in,   bottom=1.25in,   marginparwidth=1.75in,   marginparsep=.25in,   asymmetric]{geometry}  \renewcommand*\familydefault{\sfdefault} % Set default font  %%% Table of Contents ---------------------------------------------------------- \setcounter{tocdepth}{1} % Show only Chapters and Sections  %%% Change font/color/layout of TOC \makeatletter \titlecontents{chapter}[-2em] {\color{cyan}\bfseries\LARGE\addvspace{3mm}} {\makebox[4.4em][r]{\@chapapp}\contentslabel{-0.25em}\hspace{1.9em}} {} {\hspace{3em}\contentspage} \g@addto@macro{\appendix}{%   \addtocontents{toc}{\protect\renewcommand*{\protect\@chapapp}{\protect\appendixname}}% } \makeatother  \titlecontents{section}[5.3em] {\color{cyan}\large\itshape\addvspace{3mm}} {\contentslabel{0em}\hspace{3.2em}} {} {\hspace{3em}\contentspage} [\addvspace{0mm}]  %%% Chapter Header ---------------------------------------------------------- \makeatletter \titleformat{\chapter}   {\normalfont\sffamily\Huge\scshape}   {}{0pt}   {\thispagestyle{empty}    % Remove page number on new chapters   %\setcounter{definition}{0}   \begin{tikzpicture}[remember picture,overlay]     \node[yshift=-3cm] at (current page.north west)       {\begin{tikzpicture}[remember picture, overlay]         \draw[fill=cyan] (0,-1) rectangle           (25cm,3cm);         \draw[fill=cyan] (0,-24) rectangle           (25cm,-25cm);         \ifttl@label% &lt;---------------------- Added condition on \ifttl@label           \node[anchor=west,xshift=.21\paperwidth,yshift=-.01\paperheight,rectangle]               {\color{white}\LARGE \MakeUppercase{\@chapapp} \Huge\thechapter};         \fi% &lt;------------------------------- end condition on \ifttl@label        \end{tikzpicture}       };    \end{tikzpicture}\endgraf   \vskip-.7cm   \color{cyan}\Huge\raggedright\leftskip-1cm    \noindent\MakeUppercase{#1}\endgraf   } \makeatother  \titlespacing*{\chapter}{0pt}{10pt}{0pt}{}  \titleformat{\section}{\color{cyan}\itshape\LARGE}{\llap{\thesection} #1}{1em}{}[\titleline{\color{cyan}\titlerule[1pt]}] \titleformat{\subsection}{\color{cyan}\normalfont\large}{\; #1}{1em}{}  \begin{document}   \tableofcontents   \chapter{Turing Machines}     \section{The Turing Machine}     \section{Variations of the Turing Machine}       %\subsection{Non-deterministic Turing Machines}     \section{The Church-Turing Thesis}   \chapter{Decidability}     \section{The Universal Turing Machine}    \appendix   \chapter{ON COMPUTABLE NUMBERS, WITH AN APPLICATION TO THE ENTSCHEIDUNGSPROBLEM} \end{document} Can the Room of Requirement provide anything if needed? For example:   James Potter wanted to hide from Voldemort, it would have served as a perfect hiding place. Harry Potter wanted all the Hocruxes, he should have gone straight to the room of requirement where he would have found all the Hocruxes along with the Sword. All the muggle borns of the wizarding community could have taken refuge in the room of requirement. Can someone meet a dead person in the room of Requirement if needed? Would it have been possible for Harry to go in past in order to see Dumbledore for the explanation of many things? Can the room duplicate something? For instance, Harry needed the Elder wand; with Voldemort having it, could he still get it? Someone wishes to be knowledgeable than Dumbledore, would the seeker find his desired wish by finding books and things?   Who created the room of requirement (surely not Salazar)? Was it beyond Dumbledore's magic to create such a place? Problem in installing Python 3.3 in Ubuntu 12.04 Billing Information Required for App Updates I'm trying to update 3 apps on my iPad and 3 things happen that never usually happen.   It asks me to sign in. It asks for my billing information. My card gets denied.   Now I know my card still works fine so that isn't the problem. The same thing happens when I try to install previously downloaded apps (that cloud button) or install new free apps.  I have no outstanding payments (is it even possible to have outstanding payments with Apple?) so why is this happening?  In case it's needed, I'm using an iPad Air running the latest version. 16GB Harddrive and Wi-Fi only.  I should also make it clear that "None" isn't an option for payment. I have little experience with testing and I'm being hired to work on a team where I am the only tester. I'm struggling to find the best approach for the process. Being alone should I write down a test script or not? Wouldn't it take too much time? I have no experience in writing test scripts, could anyone help with a good reference (book, video or whatever), please? Algorithm for offsetting a latitude/longitude by some amount of meters Why can't I import a file in the init.m file? Hide a Subdomain from Google/Search Engine SEO Result? Einstein's big revelation was that time and space are inseparable components of the same fabric. Physical observation tells us that distant galaxies are moving away from us at an accelerated rate, and because of the difficulty (impossibility?) of defining a coordinate system where things have well defined coordinates while also moving away from each other without changing the metric on the space, we interpret this to mean that space itself is expanding.   Because space and time are so directly intertwined is it possible that time too is expanding? Or perhaps it could be contracting? Today I came across an ad on this question on SO:  (I don't expect it to stay very long).   There was a community promotion ad on the right hand side of the site, I think for one of our English sites. It had a sentence that I only partially remember:     Idiom ... poor or even poorer   I found it interesting, so I clicked that ad. Which caused a new instance of SO to open within the ad space. Unfortunately I failed to take a screenshot. I've been refreshing the page like crazy, but can't get the ad to appear again.  Edit: I managed to get a new community add, for the photography site, and captured a screenshot:   Edit2: This bug still persists, I saw it today with an OOP add from CodeReview, and an area 51 add. 32-bit vs. 64-bit systems What are the differences between 32-bit and 64-bit systems?  If you have used both of them, what kind of sharp differences have you experienced?   Would it be a problem to use 32-bit programs on 64-bit systems in some cases? What's the reason I can't create generic array types in Java? Why are differential equations for fields in physics of order two? What is the reason for the observation that across the board fields in physics are generally governed by second order (partial) differential equations?    If someone on the street would flat out ask me that question, then I'd probably mumble something about physicists wanting to be able to use the Lagrangian approach. And to allow a positive rotation and translation invariant energy term, which allows for local propagation, you need something like $-\phi\Delta\phi$.  I assume the answer goes in this direction, but I can't really justify why more complex terms in the Lagrangian are not allowed or why higher orders are a physical problem. Even if these require more initial data, I don't see the a priori problem.  Furthermore you could come up with quantities in the spirit of $F\wedge F$ and $F \wedge *F$ and okay yes... maybe any made up scalar just doesn't describe physics or misses valuable symmetries. On there other hand in the whole renormalization business, they seem to be allowed to use lots and lots of terms in their Lagrangians. And if I understand correctly, supersymmetry theory is basically a method of introducing new Lagrangian densities too.   Do we know the limit for making up these objects? What is the fundamental justification for order two? Cannot deserialize instance of time from VALUE_STRING value Proof of property of abelian group Indian passport threading coming off My Indian passport threading is coming off i.e. the cover of the passport is coming off, there are only 2 threads remaining.   Will it be a problem at the airport when going abroad ? Also anyone who has experience of getting a replacement passport fairly quick ? Because I need to get a passport in like 15 days. Does SE have a social life/relationships questions site