Actually in this case, you will want to make the column absolute, otherwise
it will just highlight what is in column A. Make a slight change to the
formula:

=$A1="Private"

--
Kevin Vaughn


"Pete_UK" wrote:

Highlight the cells in column B and click Format | Conditional Format
and choose "Formula Is" rather than "Cell Contents Is". Then in the
next panel enter this:

A1="Private"

and click the Format button - choose the Patterns tab if you want to
change the background colour and pick an appropriate colour. Click OK
twice to get out of this, and your private calls should all have the
phone number highlighted in column B.

Hope this helps.

Pete