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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 Format>Conditional 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
 
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>
 
Back
Top