Try this:

Assume cell A1 is named Initials

You want to color cells D1:D5 if Initials = TB (not case sensitive)

Select the range D1:D5
Goto the menu FormatConditional Formatting
Select: Formula Is
Enter this formula in the box on the right:

=Initials="TB"

Click the Format button
Select the Patterns tab
Select a fill color of your choice
OK out

Biff

"pilgrim" wrote in message
...
Hi all, I am trying to colour a range of cells if given cells entry = say
a
persons initials ie enter TB in a cell named Initials and a range of cells
turn to yellow?
I have looked at conditional formatting but cant see how to apply to a
range,
also looked at functions and can't seemt to decided which to use.
I have a feeling that functions would be the direction to go just need
some
advice
regards
pilgrim