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?
Subscribe to:
Post Comments (Atom)
How can I VLOOKUP in multiple Excel documents?
I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...
-
I'm working on some .bat stuff created in a legacy application, which uses many environment variables. I need to know exactly what is e...
-
Is it possible to use the tablet style on-screen keyboard on a Windows 8 laptop PC? I've found the 'Ease of Access' version whic...
-
On my desktop there are a sea of icons and I realy like ability to hide them. I can do that if do right click on desktop and find arrange ic...
No comments:
Post a Comment