fixed : copy Conditional Formatting to other cells in Numbers 2.2 (iWork ’09)

Question :

I’m using iWork’09, and when using Numbers I want to color the cells according to the value that’s in it. So for instance if the number in the cell is smaller than 10, I would like the cell’s background color to be yellow, if it’s in between 10 and 20 I would like it to be orange, and when it’s over 20 I would like it to be red.

I figured out how to do that using Conditional Formatting, and I even found out that I can select a complete row or column of cells to set their Conditional Formatting all at once, but… I’ve now created an entirely new column, and I want to copy the ‘old’ Conditional Formatting to those ‘new’ cells also…

How do I do that ?

 

Answer :

The answer is actually very straight forward, but it’s just that the naming for this may be a little confusing in Numbers… what you are looking for is ‘Copy Style’…

To set Conditional Formatting to a range of cells, just select them all, and go to Format –> Show Conditional Format Rules ; there you can set a formatting rule for each background color you would like to appear.

Then, to copy those Conditional Format Rules to other/new cells, select one of the cells that already has the Conditional Format Rules applied, and go to Format –> Copy Style

Then, select the (new) cells you want to give those same Conditional Format Rules to also, and go to Format –> Paste Style

That’s it… it really is that simple…

 

Advertisements

fixed : add sound to Screen Sharing

Question :

I am using OSX’s built-in Screen Sharing option to control the Mac in our living room, when I am in another room with my MacBook – it’s great !

But sometimes I would like to listen to a video or a music track that I’m playing on my ‘living room Mac’ and Screen Sharing doesn’t support that…

What can I do ?

 

Answer :

There’s a simple and FREE utility that will help you out on this one : Soundfly

Just download and install Soundfly on both Macs and then run “Soundfly” on the ‘sound sending Mac’, and “Soundfly Receiver” on the ‘listening Mac’… it’s that simple…

You can download Soundfly here :

http://www.macupdate.com/app/mac/26855/soundfly

UPDATE : the latest version can be downloaded here :

http://www.abyssoft.com/software/soundfly/

 

Thanks to Graham Johnstone for this updated link ūüėČ

fixed : watch YouTube on an ‘underpowered’ G4 iBook

Question :

I am (still) using an iBook G4 and I very content with it most of the things I use it for. (Even in this day & age of OSX 10.8 “Mountain Lion” and Intel-Macs, I’m still happily using MacOSX 10.5.8 “Leopard” on a PowerPC-Mac…)

And even though Safari 5.0.6 is still doing great for me for regular web browsing, it chokes on YouTube…

How can I fix this ?

Answer :

The iBook G4’s graphics card performance is rather ‘underpowered’ compared to current Macs…

Just install MacTubes, it’s a FREE dedicated application that will run current YouTube-video’s far more smooth than YouTube.com in Safari :

http://www.macupdate.com/app/mac/28608/mactubes

fixed : iCloud Photo Stream from business iPhone to family Mac

Question :

My iPhone is a business device, so I want to sync my ‘business life’ including Contacts, Calendars, Mail, Documents & Data, etc to my MacBook Pro… but I want my upload/sync the photo’s I’ve made with this ‘business’ iPhone to our shared ‘family’ Mac which holds our family’s entire iPhoto-database. iCloud doesn’t seem to enable me to do so… what can I do ?

Answer :

Even though you can setup a secondary iCloud account on your iPhone, you cannot do what you would like to do, because :

1- Photostream is only supported for your primary iCloud account (*)

(*) UPDATE d.d. September 20th 2012: only when running iPhoto 9.4 or newer on OSX 10.8.2 or newer, you have the option to subscribe to a ‘Shared’ Photo Stream besides your primary iCloud account’s Photo Stream

If you want to this ‘Shared Photo Stream’ feature on an older, officially unsupported Intel-Mac, you could consider installing a patched version of OSX 10.8 – for more info, look here :

fixed : install OSX 10.8 Mountain Lion on unsupported Macs

 

2- Documents & Data syncing is only supported for your primary iCloud account

…so using iCloud you will never be able to make the logical split between Documents & Data sync (which is strictly ‘business’) and Photostream (which is mainly ‘family’)…

The only solution at this moment is to find an alternative to Photostream… and I’ve found (only) one :¬†Eye-Fi does the trick !

And… Eye-Fi is free (free account, free iOS-app & free Mac-app ; by SanDisk)

download it here for OSX :

http://support.eye.fi/downloads/center/

and download the iOS-app here :

http://itunes.apple.com/en/app/eye-fi/id306011124?mt=8

the only thing you need to beware of is that the Eye-Fi App needs to be running/open on your iPhone/iPad and on your Mac both Eye-Fi Center and iPhoto need to be running/open…

…so it still feels a little more ‘manual’ than iCloud Photostream, since you need not forget to open the Eye-Fi App…

…but that’s a small price to pay, since you get 3 things that iCloud doesn’t give you :

– auto-transfer of your video recordings into iPhoto

– a free online gallery (like the one we lost when ‘upgrading’ from MobileMe to iCloud)

– separation of your ‘photostream’ from your primary iCloud-account

Note :

even though using DropBox might seem to be a valid alternative to iCloud’s Photostream also, since it does auto-upload of iPad/iPhone pictures to ‘the cloud’… it is not really useful in the end, as it does not provide auto-import into iPhoto…

fixed : 10.8 refusing to see the Atheros AR9280 (same error as in 10.7, including alternative solution !)

Question :

After installing OSX 10.8 “Mountain Lion” on my Mac which has an Atheros AR9280 AirPort-card, I am not able to get any WiFi-connection, and when I click on the (piece-of-pie shaped) AirPort-icon in the upper menubar in the Finder, it indicates “WiFi: no hardware installed”. How can I fix this ?

Answer :

—- updated answer ——

if you get a ‚ÄúWiFi: No Hardware Installed‚ÄĚ-error, get the¬†KextUtility for OSX 10.8¬†and install the¬†Edited Atheros Kext for Lion*3

—– original answer ——

Thanks to Thomas and Josh, I can now present to you the solution to the “WiFi: no hardware installed”-error in OSX 10.8 “Mountain Lion” :

if you encounter the “WiFi: no hardware installed”-error after installing OSX 10.8, do this :

– go to [your hard disk] –> System –> Library –> Extentions –> IO80211Family.kext

– CTRL-click on the¬†IO80211Family.kext and select “Show Package Contents” from the pulldown menu

– then go to Contents –> Info.plist and drag the Info.plist to the Desktop

– CTRL-click on the Info.plist (the one on the Desktop) and select “Open with –> TextEdit” from the pulldown menu

– then, inside the Info.plist file, find and delete these line (found near the end) :

<key>OSBundleRequired</key>
<string>Network-Root</string>

– then select File –> Save to save the edited version of the Info.plist on your Desktop

– then, drag the Info.plist from the Desktop back onto the original version that is in System –> Library –> Extentions –> IO80211Family.kext –> Contents

– in the warning window that pops up, click on “Authenticate” and type your administrator login and password

…that should be it !

now your AR9280 should be recognized by OSX 10.8 “Mountain Lion”, and the “WiFi: no hardware installed”-error should be gone

Donate Button (all)

FYI :

the original solution by Thomas (based on the directions from Josh) can be found here :

https://macmanusnl.wordpress.com/2012/02/11/10-7-3-refuses-to-see-the-atheros-ar9280/#comment-446

tip : put a OSX 10.8 “Mountain Lion” installer on a USB-stick

If you just have one Mac you want to install OSX 10.8 “Mountain Lion” on, you can just (buy and) download the installer from the Mac App Store.

But if you need to install OSX 10.8 “Mountain Lion” on multiple Macs, the fact that the download process regularly is very slow, will make you want to skip the downloading if possible.

You can do so easily by creating a dedicated USB-stick with the OSX 10.8 “Mountain Lion” installer on it, which is quite easy :

– get yourself a brand-new 8GB USB-stick

– buy & download OSX 10.8 “Mountain Lion” from the Mac App Store, but… you need to make sure the installer will not be ‘cleaned up’ (= deleted) after the installation has finished : the easiest way to do so is to wait for the download to complete, and then when the installer window pops up, do not start to install right away ; first, go to the Finder and into the Applications folder, then right-click on the “Install OSX 10.8 Mountain Lion” application, and select “Compress “Install OSX 10.8 Mountain Lion””… then wait for the compression to complete… when that’s done, you can continue to the installer window and install OSX 10.8 “Mountain Lion”

[ if you’ve already installed OSX 10.8 “Mountain Lion” and the installer has already been ‘cleaned up’ (= deleted), you need to re-download OSX 10.8 “Mountain Lion” from the Mac App Store ]

–¬†download the “Lion DiskMaker” app from here :

http://blog.gete.net/lion-diskmaker-us/

– then double-click on the .zip-version that is now/still in your Applications folder ; that will place the original installer application back

– then run the “Lion DiskMaker” app, and follow the instructions given

…it’s that easy

Note :

– additional instructions can be found on the page that you’ve downloaded “Lion DiskMaker” from

– reformatting of the 8GB USB-stick will be done by the “Lion DiskMaker” app also

– it is highly recommended to create the installer on a dedicated USB-stick ; even though it is possible to burn the installer to a DVD, do not do so, since that will be extremely slow to startup from during installation – also, do not put the installer on a (partition of) a external drive that has other data on it… it might wreck your data if things mess up during creation, and it’s not as practical for actual use…

fixed : get iCloud on the officially unsupported OSX Snow Leopard – sync works !

— UPDATE —

–0– to start off, it is now essential to make sure 2-factor¬†authentication¬†is OFF :

  • go to https://appleid.apple.com/account/home
  • login with your Apple ID (= iCloud ID)
  • then at Security go to Two-factor Authentication and turn it OFF
  • and don’t forget to logoff¬†from the AppleID-website

(thanks to Lowell Mills for pointing this out)

— ORIGINAL POST —

thanks to one last hint from ‘Joseph Sturkey’, I can now present you the solution to getting your ‘Snow Leopard’-Mac to work with iCloud :

–1– find your iCloud Server-number and your 9-digit iCloud Account-code :

How to find your iCloud server and 9-digit iCloud user code :

– on your Mac, open Safari and go to http://www.icloud.com
– login using your AppleID e-mail address and AppleID password
– click on Calendar
– the online calendar layout now opens
– now go to Window (in the upper menu bar, next to Safari’s Help-tab) –> Activity
– in Activity window that opens you’ll find the text “iCloud Calendar” in bold letters, just below it, you’ll find 3 lines that look like this :

http://icloud.com
https://p0X-contacts.icloud.com/123456789/wcs/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
https://p0X-contactws.icloud.com/co/mecard/?dsid=123456789&id=yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy

Рremember that p0X-prefix and the 123456789-code ! you are going to need those in the following steps !

—- UPDATE —-

recently these lines seem to have changed into something that looks like this :

http://icloud.com
https://p1X-contactws.icloud.com/co/mecard?/clientBuildNumber=xxx….xxid=1234567890&id=yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyom
https://p1X-contactws.icloud.com/co/mecard?/clientBuildNumber=xx&#8230;.xxxx&id=yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy&method=POST

in that case, remember the p1X-prefix and the 1234567890-code ! those are the ones you will need in the following steps !

—————–

(the p0X-prefix is your iCloud Server-number, and the 123456789-code is your 9-digit iCloud Account-code ;¬†note that in some rare cases it is not a 9-digit code, but a 8-digit or 10-digit one…)

—- UPDATE —-

the iCloud Contacts-syncing trick outlined below will only work if your AppleID’s password contains alphanumeric digits only (so letters and numbers only, nothing else)

if your current AppleID’s password does not, you will need to change it before proceeding. To change your AppleID’s password, go here :

http://appleid.apple.com

Please note that this will mean you will have to re-type your new password for every use you have for your AppleID… so for eMail, for iTunes, for Home Sharing, etc.

———————

–2– Repair Disk Permissions

– open Programs –> Utilities –> Disk Utility

– select your internal hard drive’s main partition (the one you have MacOSX running on) form the list on the left

– select the ‘First Aid’-tab

– click on “Repair Disk Permissions”

…and wait for it to finish

–3– turn on iCloud Calendar syncing :

– open iCal on your Mac

– go to iCal –> Preferences

– in the window that opens, click on the ‘Accounts’-tab

– click on the ‘+’-button

– in the ‘Add Account’-window that opens, select “Account Type: CalDAV”

– at ‘E-mail address:’ type your AppleID-account’s login eMail address

– at ‘Password:’ type your AppleID password

– at ‘Server address:’ type “p0X-caldav.icloud.com”

(in which the p0X-prefix should correspond with the p0X-prefix you’ve found in step 1)

– then click the ‘Create’-button

– the iCloud CalDAV account you’ve just created will now be listed on the left

– in the ‘Account info’-tab, at ‘Description:’ type “iCloud Calendar sync”

– at ‘Calendar synchronization:’ select “Every minute” (or any other option, but do not select “Push”)

– leave the rest as it is set automatically

– then select the ‘Server settings’-tab, make sure that ‘Use SSL’ is checked

– leave the ‘Port:’ setting empty (it will display “Automatic” in grey) ; if that doesn’t work you might try setting it to “443”

– put a check mark in front of “Use SSL”

– do NOT put a check mark in front of “Use Kerberos”

Рnote : the 9-digit number from the Server Path is your 9-digit iCloud Account code ! 

– exit the iCal Preferences by clicking on the little red button in the upper left corner

–4– prepare Address Book and iCloud Contacts for syncing :

– open Address Book on your Mac

– IMPORTANT : now delete any profile pictures from ALL your contacts, as these will create unwanted duplicates when syncing [ that’s right‚Ķ everything comes with a price‚Ķ ] and remember to never use new profile pictures until you stop using MacOSX 10.6 ‘Snow Leopard’

– now drag the group (from the list on the left) called “All contacts” (might also be called “On My Mac”) to the desktop of your Mac to create a backup called “All contacts.vcf”

– go online to http://www.icloud.com

– login using your AppleID and password

– then select “Contacts”

– then select all contacts by selecting just one and then pressing the [CMD] + [A] keys on your keyboard at the same time

– then click on the ‘gearing wheel’-icon (a.k.a. ‘sprocket’-icon) in the lower left corner and choose “Delete” from the popup list

– in the ‘Are You sure?’-window that opens, click on “Delete”

– now your iCloud contacts list will be completely empty

– click on the ‘gearing wheel’-icon (a.k.a. ‘sprocket’-icon) in the lower left corner and choose “Import vCard‚Ķ”

– in the pulldown window that opens, go to your Desktop folder to select the “All contacts.vcf” file you have previously created, and click “Select”

Рthen wait for all contacts to import…

– when all have been imported, select the iCloud button in the upper left corner to return to the main iCloud page and click “Log out” in the upper right corner

– then on your Mac, go to Address Book

– select on of your contacts and then press the [CMD] + [A] keys on your keyboard at the same time to select them all

– then press the ‘backspace’-key (a.k.a. ‘backwards delete’) on your keyboard and click on “Delete” to confirm deletion of all your contact

– now your contacts list will be completely empty

REMEMBER : do not add any profile pictures ever again to any of your contacts !

–5– turn on iCloud Contacts syncing :

– then on your Mac, go to Address Book –> Preferences

– in the window that opens, click on the ‘Accounts’-tab

– click on the ‘+’-button

– in the ‘Add Account’-window that opens, select “Account Type: CardDAV”

– at ‘User Name:’ type your AppleID-account’s login eMail address

– at ‘Password:’ type your AppleID-account’s password

– at ‘Server address:’ type “p0X-contacts.icloud.com” (with p0X according to your previously found iCloud server prefix)

– click “Create”

– despite the warning that the account settings couldn’t be fetched, click on “Create” again

– then quit Address Book immediately, by pressing the small red button in the upper left corner, and clicking on Address Book –> Quit Address Book from the menu bar

[ Note : quitting Address Book is a very important step in the setup process ! ]

– now in the Finder go to Users –> [your user home folder] –> Library –> Application Support –> Address Book –> Sources –> [folder with an enormous alphanumeric name] –> Configuration.plist

– right-click ( a.k.a. [CTRL]+[mouse click] ) on this Configuration.plist file and select “Open using‚Ķ” –> “Textedit” from the popup list

– then in Textedit, find the following line :

<string>http://:0(null)</string&gt;

– change it to this :

<string>http://p0X-contacts.icloud.com:443/123456789/principal</string&gt;

(with p0X according to your previously found iCloud server prefix, and 123456789 according to your 9-digit number from the iCal-CalDAV Server Path)

– then two lines below you will find the following line :

<string>yourname@me.com</string>

(in which “yourname@me.com” is the eMail address that you use as your AppleID iCloud login)

– change it to this :

<string>yourname%40me.com:password</string>

(with the “@”-sign being replaced by “%40” and “password” being your AppleID iCloud password)

– then select File –> Save and exit Textedit

– now open Configuration.plist again in Textedit to see if the changes were properly saved, and if so, exit Textedit

– then open Address Book and go to Address Book –> Preferences

– select the ‘Accounts’-tab

– select CardDAV from the list on the left

– select the ‘Account info’-tab

– at ‘Description:’ type “iCloud Contacts syncing”

– at ‘User Name:’ type “your name%40me.com:password” (exactly the way you’ve typed it in the Configuration.plist file previously)

– at ‘Password:’ type ” ” (just a single space)

– then select the ‘Server settings’-tab

– at ‘Server address:’ type “p0X-contacts.icloud.com”

(with p0X according to your previously found iCloud server prefix)

– at ‘Server path:’ you won’t be able to change anything, but it should be a “/”, then your 9-digit code, followed by “/principal”

– at ‘Port:’ type “443”

– and add a check mark next to “Use SSL”

– then close the Preferences panel by clicking on the red dot button

–6– do a quick check in Address Book :

– open Address Book, and you’ll see these groups : All Contacts (brown icon), iCloud Contacts syncing (blue icon), On My Mac (brown icon), iCloud Contacts syncing (brown icon) and possibly also Last Import (green icon)

——– UPDATE ——-

if you do not see “iCloud Contacts syncing” listed twice (once with a brown icon and once with a blue icon), your iCloud-sync is not setup properly ; the probable cause is that your AppleID’s password can only contain alphanumerical digits (so letters and numbers only, no question marks, no exclamation marks, no at-signs, no hashtags, no…)

to adjust your AppleID’s password, go here :

http://appleid.apple.com

—————————-

– if there are any Contacts in the ‘On My Mac’-group, make sure they are in ‘iCloud Contacts syncing’ also, and if not, copy them over

– then delete any Contacts (and sub-groups) from the ‘On My Mac’-group… you will not be using those any longer…

– if updating / syncing with iCloud seems to work slowly, you can double-click on the ‘iCloud Contacts syncing’-groupname (either with the blue or brown icon in front of it) and you will see a spinning wheel for a few seconds to indicate the syncing is being done [ this is the way to manually push the updating process ]

–7– iCloud syncing is now setup, but keep this in mind :

– iCloud syncing with any officially unsupported device (like a Mac running MacOSX ‘Snow Leopard’) is not as instantaneous as you might expect it to be… it may take up to a minute or so to upload/download sync info with iCloud [ so you might want to use a ‘manual push’ to speed up the updating process ]

– AGAIN : using (profile) pictures in your Contacts-database will corrupt syncing to and from your ‘Snow Leopard’-Mac, so again : remember not to use any (profile) pictures for any of your contacts (including yourself and Apple Inc. also…)

for more info, please have a look here also :

https://macmanusnl.wordpress.com/2012/06/25/get-icloud-syncing-on-osx-snow-leopard/

Donate Button (all)