change pattern in a range of cells if a given cell =
 

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

change pattern in a range of cells if a given cell =
 

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

change pattern in a range of cells if a given cell =
 

One way:

Select the range, for example A2:J100, with the initials in column B.

With A2 active (i.e., its address in the Name box on the formula bar),
choose Format/Conditional Formatting and use the dropdown and inputbox
to enter

CF1: Formula is =$B2="TB"
Format1: <patterns/<yellow

In article ,
pilgrim wrote:

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