David Underwood’s Professional Blog

Formula is: =IF($G1=”visa”,true,false)
Do this somewhere in row 1, then copy the format everywhere you need it. The
$ sign locks the formula on column G, while the row number is floating.
–
Best Regards,

Luke M

reply

Thank you, but I’m asking specifically about conditional formatting.
ExcelObsesse posted on Friday, December 07, 2007 3:06 PM

Thank you, but I’m asking specifically about conditional formatting. So,
going into format –> conditional formatting,  I need to enter a formula to
automatically highlight the entire row rather than just the individual cell.
Thoughts? Thanks again!

reply

That is the formula to use with the conditional format.
Luke posted on Friday, December 07, 2007 3:13 PM

That is the formula to use with the conditional format. You can copy
conditional formats from one cell to another.

Once you have the conditional format in once cell, copy, then select desired
area(or all, with Ctrl+A) to be affected, and right-click, paste special.
Choose format.

http://www.eggheadcafe.com/software/aspnet/31287951/conditional-formatting-fo.aspx

O’Reilly Book, Chapter 26
Active Directory and PowerShell

Snippet to Create User
ExpertsExchange

Managing AD With PowerShell
MSDN Blog

CSVDE and LDAP Properties

LDAP Schema
Florida State

Running PowerShell Scripts
O’Reilly

How To User PowerShell to Bulk Import Users
MS Server Admin

This is a great feature for the sysadmin… create a new folder and rename it to:

GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

Read some more here:

http://news.cnet.com/8301-13860_3-10423985-56.html

Twitteresque quick posts of links and information!

Why doesn’t my new column show up when I add or edit my list?
When adding a column to a list in SharePoint and using a template you may not see it in the New Item or Edit Item forms.
Sharepoint 2007

I found this neat article online when looking to combine two Quicktime files before encoding as a Flash video using the FLV encoder…

I am creating a site for our church utilizing Wordpress as a CMS and wanted to generate a quick favorite icon. Icon Composer to the rescue! I grabbed a gif of the PCUSA logo off a Google image search, did some conversion in Illustrator, dropped my resultant PNG into Icon Composer and boom! a nice favicon.

I’m including the files as a download for other churches to use.

Icon Composer is part of the Apple Developer Tools

Download the PCUSA Logo Pak here

I noticed several NFS volumes of servers that no longer existed attempting to be automounted in OS X. I found a post online to disable the automount for the server AD and it worked well for me.

The article can be found at http://www.macosxhints.com/article.php?story=20030211060027212

For several months now, my automated nightly incremental backups to an NSF-mounted remote device have been failing. After many false leads, I finally traced the problem to the program automount in /usr/sbin.

This program causes the remote disk to disappear when you log out, and things like remote backups at 2am will then fail. They even fail if you are logged in but the screensaver comes on. This unfortunately is (now) the default behavior, and automount, without asking or warning you, hijacks your NFS mounting point, moves it to its own directory, and creates an alias. I wonder if Bill Gates wrote this? Anyway, you can turn it off by editing the file /etc/hostconfig and changing the line AUTOMOUNT=-YES- to AUTOMOUNT=-NO-.

This will take effect after a restart. If you currently have NFS devices that have been automouted, you will have to unmount them by hand, delete the alii created by automount, remake the corresponding directories for the local mount points and then remount.

This can all be done in NSF manager except for the last step, which now fails with a cryptic “system error 255″. You can get around this by mounting with the root command mount -a.

Now my backups work at 2 am like they are supposed to.

We have several sites in our local network that have found their way onto Internet Explorer 8’s bad list when it comes to XSS. These are not necessarily sites we have developed but part of 3rd party published applications that provide a web interface. There’s a quick way to disable this for trusted sites through IE settings which I will show below. First, let’s take a look at what XSS is…

What is XSS? Is it like CSS?
XSS stands for “Cross-Site Scripting.” It is one of manymethods a hacker can use to exploit a site and gain information from a user. Basically code (usually Javascript) is injected or included in a page that makes referece back to another site providing a method for access and transmission of information. For examples see the cheat sheet of code at this site. You can also read the Wikipedia article.

How do I bypass the filter for trusted sites?
Generally you woudn’t want to turn the XSS filtering in IE 8 off at a global level unless there is a great reason to do so. What I have done is added the site I want to adjust to my trusted sites group and then manipulated my trusted site settings.

Head to Tools -> Internet Options -> Security. Click on “Trusted Sites” and click the “Custom Level” button.
Scroll down in the options until you see “Enable XSS Filter” and choose “Disable”

While you are in there you also may want to adjust for mixed http and https content. You can do that in the heading “Display Mixed Content” 

I hope you found this post useful … it’s just one of those things we learn as IE 8 is used more. Overall I’m very thankful for the update IE 8 has provided.

Learn Objective-C

In reading “Learn Objective-C on the Mac” by Mark Dalrymple (Author), Scott Knaster (Author) I ran across a great quote that I felt was worth posting here on my blog. The quote is as follows: An old saying in programming goes something like this, “There is no problem in computer science that can’t be solved by adding another level of indirection.”  When looking at many of the various languages programmers work with on a daily basis it is easy to see how indirection is becoming increasingly popular and a forefront of new language introduction. C, C++, and Objective-C have made use of this throughout from the simple use of variables and pointers, to file and database references for application settings. As programmers have become more accustomed to OOP (Object Oriented Programming) practices we have learned to extend the OO approach to our lives and other realms of computing. A great example of this can be found in the forefront of Web 2.0. The new approaches to data sharing and mash-ups on the web today speak volumes on how OOP has gained roots not only at the desktop level but in web applications as well. Several years ago web applications were minimal, not robust, and inline, not OO. The emergence of greater and more usable frameworks and methods of development on the web application sphere has created a volume of wonderful web applications that have begun to rival that of desktop applications (think GMail, Facebook, MySpace, YouTube, etc). Such acceptance of SaaS (Software as a Service) and Cloud Computing has lead us down a road where we are using the concepts of indirection outside to programming world and injecting it into daily enterprise and personal computing. It will be interesting to see how far we can go in the next few years to greater share and extend our data to multiple devices and mash it up (to say in Web 2.0 speak) into a singular personal computing experience. Ahh– Indirection.

This is just a note for folks out there that when you allow connections by IP on your receive connector and you add an IP that you sometimes will need to restart the transport for Exchange to pick up the new changes.