|
Re: Controlling visibility of cells in Excel
Sanddrag,
The spreadsheet I just made up does it in two different ways. The first worksheet uses conditional formatting to check if the cell value is greater than the inputted cutoff. If it is, the text is set to white. This method depends on you having all the data pre-generated.
The second version calculates the data each time. Given an inputted limit and increment (adds some versatility), it generates your list of angles. The formulas are all their for you to play with. I find Excel much easier to learn via re-engineering as opposed to explainations. So I've attached it.
It's late, so it might not be perfect...
Also, there's probably a better way to do it, there always seems to be with Excel.
__________________
:: Karthik Kanagasabapathy :: "Enthusiasm is one of the most powerful engines of success. When you do a thing, do it with all your might. Put your whole soul into it. Stamp it with your own personality. Be active, be energetic, be enthusiastic and faithful and you will accomplish your object. Nothing great was ever achieved without enthusiasm" -- R.W. Emerson
My TEDx Talk - The Subtle Secrets of Success
Full disclosure: I work for IFI and VEX Robotics, and am the Chairman of the VEX Robotics and VEX IQ Game Design Committees .
|