Conditional Formatting

T

tracyt620

Hi there wonder if someone can help i have 4 rows with rows 2 and 4 wil
showing users names I want to look in row 2 for a value in row 4 and i
this is there I want it to appear orange - I think conditiona
formatting is the way to do it but not sure of the formula that shol
be in there - any help would be appreciated :confused
 
S

swatsp0p

In Cond. Formatting use:

Formula Is: =A4="yourvaluehere"

click Format and on the Patterns tab, set the fill color to orange.

Of course, adjust the cell reference (A4) to meet your needs

HTH

Bruc
 
T

tracyt620

thanks for your help i've tried this but is still doesnt work - an
other suggestions
 
S

swatsp0p

If that doesn't work, you will have to give more details. Wha
<exactly> are you trying to do? Give specific cell references an
contents so it can be replicated.

Also, what happened when you followed the instructions given?

Bruc
 
T

tracyt620

thanks for this Bruce

row 1 - )cell a)we 19th August 2005
row 2 - (cell a) Tracy Toal - (cell b) Micky Mouse - (cell c) Donald
Duck
row 3 - (cell a) we 26th August
row 4 - (cell a) Tracy Toal - (cell b) Pluto

I want cell a of row 4 to be orange so that is show Tracy Toal appears
in row 2 and 4

hope this makes sense
 
S

swatsp0p

OK, try this:

In cell A4 click Format>Conditional Formatting...

Under Condition 1: Cell Value Is: choose "Equal to" and enter "=A2
(no quotes)

click Format and select your fill color from the Pattern tab.

Note that this will highlight A4 whenever it is the same as A2.

If you specifically want to look for "Tracy Toal" then:

use Formula Is: and enter: =AND($A$4="Tracy Toal",$A$2="Tracy Toal")

click Format and select your fill color from the Pattern tab.

Does this work for you
 
S

swatsp0p

One other point... If you want to Highlight A4 if Tracy Toal i
<anywhere> in row 2, modify the Formula Is: to this:

=AND($A$4="Tracy Toal",MATCH("Tracy Toal",A2:H2,0)>0)

where A2:H2 is the range in row 2 you want to look for Tracy Toal.

HTH

Bruc
 
S

swatsp0p

Again, can you be more specific? What do you mean by 'hardcoding'? I
you mean rather than use the typed out name, you can use a cel
reference that contains the name instead. As in my earlier example yo
could change the A2 reference to any cell you want to compare to. e.g
if the name is stored in G5, use that reference instead.:

In A4> Under Condition 1: Cell Value Is: choose "Equal to" and ente
"=G5" (no quotes)

Is that what you meant?

Bruc
 
Top